10.9.�Schedule Server Maintenance

The server maintenance utility is designed to perform automated maintenance on your server. Server maintenance should be performed on a regular basis to ensure the smooth operation of your server.

Note

When server maintenance is performed, a VACUUM FULL ANALYZE operation is run on your server, followed by a REINDEX. The user who schedules server maintenance must be a superuser (i.e., have the ability to create system users). For more information on the VACUUM, ANALYZE, and REINDEX operations, visit the PostgreSQL website at http://www.postgresql.com.

To run the server maintenance utility, select the "Schedule Server Maintenance" option. The following screen will appear:

Schedule Server Maintenance

When scheduling server maintenance, you are presented with the following options:

Action

Displays the name of the action to be performed by the Batch Manager. In this case, the name of the action is serverMaintenance.

Response Email

By default, the email address of the logged-in user will be entered here. This address may be edited or changed.

Scheduled

Select one of the following Schedule options:

ASAP: Select to have the job run as soon as possible.
Scheduled: Schedule a date and time to run the job. Specify a date in the first field using a standard date format. Use the arrow buttons in the second field to specify a time of day.

Note

When a job is submitted to the Batch Manager with a scheduled time of ASAP, the Batch Manager sets the scheduled time to the current time. However, a job will not necessarily be run immediately if it is scheduled for the current time. Any pre-existing jobs with scheduled times prior to the current time must be completed first. In other words, ASAP jobs will not necessarily be run immediately. Previously scheduled jobs will be run first.

To the far right of the screen, the following buttons are available:

CANCEL: Closes the screen without performing server maintenance, returning you to the application desktop.
SUBMIT: Select to submit requested action to the Batch Manager for processing. For additional information, see Section�10.5, “Topic: Submitting Reports and Jobs to the Batch Manager”.