Sage ACT! includes maintenance commands such as Integrity Checking and Reindexing that may be manually run from the Tools menu. You may also run these commands automatically, and routinely to keep your database optimized and prevent errors. In this week’s tip, I’ll show you how to automatically schedule routine maintenance.
Scheduled maintenance should be performed regularly to ensure your database is structurally sound, and performing at its best. To set up an automated schedule for database maintenance:
1. Click Tools > ACT! Scheduler…
2. In the Sage ACT! Scheduler window, below Schedule Tasks, click Create a task.
3. On the “Select a Database” page, browse to, and select your database .PAD file. Then enter a Sage ACT! Administrator user name and password. Click Next.
4. On the “Select a Task” page, from the Task list, select Database Maintenance, and then click Next.
5. On the “Database Maintenance Options” page, select both options:
Integrity Check will check the database/table structure for errors and repair any that are found.
Re-index will reorganize indexes in the database to optimize the speed with which you are able to locate data. Indexes expedite locating data in large data sets, much like the index in the back of a book points you to a page containing information that you are interested in.
6. On the “Set a Schedule” page, select how frequently you would like to execute the maintenance task. This is somewhat dependent on how often you are modifying data, but as a general rule, run maintenance weekly. If you frequently (multiple times a week) delete/update/import hundreds of records, then you may want to run maintenance multiple times a week. Furthermore, maintenance should be run on off-hours when other users are not using the database.
7. After setting the schedule, click Finish.
8. Back on the “Sage ACT! Scheduler” page, verify that the service is started. Under Other Tasks, the Start Service option will be grey if the service is currently running.
9. Click Exit.
In addition to setting up Database Maintenance to run automatically, you may run through the above steps and select Database backup to routinely backup your database.