Configuring the Scheduler › Automate Database Maintenance

Automate Database Maintenance

You can automate the database maintenance. The scheduler performs internal database maintenance once a day. It does not process any events during maintenance, and it waits for the maintenance activities to complete before resuming normal operations.

Follow these steps:

1. Click Start, Programs, CA, Workload Automation AE, Administrator.

   The Instance - CA Workload Automation AE Administrator window opens.

2. Select an instance from the Instance drop-down list in the Settings pane.
3. Click the Services icon on the toolbar.

   The Services - CA Workload Automation AE Administrator window appears, displaying a list of services installed on the selected instance.

4. Right-click the scheduler and select Stop.

   The scheduler stops.

5. Click the Scheduler icon on the toolbar.

   The Scheduler - CA Workload Automation AE Administrator window appears.

6. Click the Database Maintenance tab, complete the following fields as appropriate, and click Apply:

   Command

   Defines the location of the DBMaint.bat batch file.

   Default: %AUTOSYS%\bin directory

   Notes:

   • You can modify the DBMaint.bat batch file. However, we recommend that you make a copy of the file and modify the copied version. For information about how the DBMaint.bat batch file runs, see the Administration Guide.
   • On UNIX, the equivalent configuration parameter is DBMaintCmd.

   Start Time

   Defines the time when the database maintenance command runs the maintenance script.

   Default: 3.30 a.m.

   Limits: 24-hour format

   Note: On UNIX, the equivalent configuration parameter is DBMaintTime.

   Note: You must schedule the maintenance command to run when the system activity is minimal. We recommend that you configure your system to back up the database during the maintenance cycle.

7. Click the Services icon on the toolbar.

   The Services - CA Workload Automation AE Administrator window appears, displaying a list of services installed on the selected instance.

8. Right-click the scheduler and select Start.

   The scheduler starts. The database maintenance is automated.

More information:

Scheduler