::: Captivate :::
Thursday, July 29, 2010
  Register Login
Sign Up for our Newsletter
Minimize
First Name
Last Name
Email Address

Sign Up

Contact Us:
Minimize

Telephone:

 [626] 795-6584

Toll-Free:

 [800] 799-6584

 

 

E-mail:

 info@bullfrogsolutions.com

Address:

 2014 Teagarden Lane

 

 Alhambra, CA 91801

You are here: Support * ACT! Tips and Tricks * Automatically Perform ACT! Database Maintenance
Automatic ACT! Database Maintenance
Minimize
Any Administrator or Manager user can create a regular schedule for database maintenance. The computer must be running at the scheduled time of maintenance, however, the ACT! program does not need to be open. Follow the steps below to use the ACT! Scheduler to automate your database maintenance task.
  1. Click the Tools menu, and then click ACT! Scheduler . The ACT! Scheduler - Create, Edit or Delete a Task panel appears
  2. Click Create a task from the Schedule Tasks box. The ACT! Scheduler - Select a Database dialog box appears
  3. Click the Browse button. An Open dialog box appears. Navigate (if necessary) to, and then Open the desired database (.PAD) file. The ACT! Scheduler - Select a Database dialog box reappears.
  4. Enter the User name and (if necessary) the Password for this database, and then click Next . The  ACT! Scheduler - Select a Task dialog box appears
  5. Click Database maintenance from the Task drop-down list, and then click Next . The ACT! Scheduler - Database Maintenance Options dialog box appears
  6. It is recommended that you leave Integrity Check (Checks you database for error and repairs any that are found) and Re-index (Re-organizes the database storage area to increase access and speed) options enabled, and then click Next . The ACT! Scheduler - Set a Schedule dialog box appears
  7. Enable an Occurs option of Hourly , Daily , Weekly or Monthly , and then enable the appropriate parameters corresponding to that option as follows:

    Note:
    Your computer must be running at the time that these tasks are scheduled for. However, the ACT! program does not need to be running.

    Hourly - Between a starting hour and an ending hour that you specify.
    Daily Every weekday (M - F) or  Every (number of) days that you specify, up to 31 days.
    Weekly - Every (number of) Weeks on a weekday that you specify.
    Monthly - Every Month or Every other month scheduled on a specific day of the month or the First , Second , Third , Fourth or Last specific day of the week.

  8. When your maintenance schedule is specified, click Finish . The  ACT! Scheduler - Create, Edit or Delete a Task panel reappears with your scheduled task(s) displayed.
  9. Ensure that the ACT! Scheduler service is running. You can identify if the services is running by the state of the ACT! Scheduler icon in the system tray.

    To Start the ACT! Scheduler Service:
    1. Launch ACT!.
    2. Click the Tools menu, and then click the ACT! Scheduler option. The ACT! Scheduler - Create, Edit or Delete a Task panel appears.
    3. Click the Start Service option from the Other Tasks section.
    4. Click Exit to close the ACT! Scheduler - Create, Edit or Delete a Task panel.

    To Stop the ACT! Scheduler Service:

    1. Launch ACT!.
    2. Click the Tools menu, and then click the ACT! Scheduler option. The ACT! Scheduler - Create, Edit or Delete a Task panel appears.
    3. Click the Stop Service option from the Other Tasks section.
    4. Click Exit to close the ACT! Scheduler - Create, Edit or Delete a Task panel.
  10. Click Exit to return to the database or select your task, and then click Edit a task to change the task or click Delete a task to delete the task.

For complete details about the ACT! Scheduler. please refer to the following Knowledge Base Answer: Title: How to Manage the ACT! 2007 Scheduler Answer ID: 19214

Privacy Statement | Terms Of Use
Copyright 2007 by Bullfrog Solutions, Inc. All Rights Reserved
How to Automatically Back Up Your Database :: Automatically Perform ACT! Database Maintenance