Source: eGrabber Newsletter
Did you know that you can create a schedule in ACT! for database maintenance? It is enough if the computer is running at the scheduled time; your ACT! need not even be open for the automatic maintenance. Here's how you can do it:
1. Select Tools >> ACT! Scheduler.
2. Click on 'Create a task' from the Schedule Tasks box.
3. Use the Browse button and navigate to the database you would like to schedule the maintenance for.
4. Enter a User name and Password for this database.
5. Select 'Database maintenance' from the Task drop-down list, and then click Next
6. Enable Integrity Check and Re-index options. Click Next.
7. Use the Set a Schedule dialog box to specify the schedule and click Finish.
8. To Start the ACT! Scheduler Service, select Tools >> ACT! Scheduler and click on the Start Service option from the Other Tasks section. Click Exit.
Note: Only an Administrator or Manager user can create a schedule for ACT! database maintenance.