Creating a maintenance plan

To simplify administration, you can set up a maintenance plan for your database that is executed automatically by the database server. A maintenance plan consists of a schedule for performing one or more of the following tasks:

validating the database
backing up the database
managing maintenance plan reports

In Sybase Central you create a maintenance plan by using the Create Maintenance Plan Wizard. Only one instance of a maintenance plan can run at a time. Each time the maintenance plan runs, a maintenance plan report is saved in the database. You can view this report from Sybase Central and optionally you can have the maintenance plan report emailed to you after the maintenance plan executes on the database.

Customizing maintenance plans

Understanding the maintenance plan status

When a maintenance plan is running, its status appears in the Maintenance Plans folder in Sybase Central. A running maintenance plan has one of the following statuses:

Initializing Disables new connections and disables current users.
Running prevalidation Runs user-defined operations (if any were specified when the maintenance plan was created).
Validating pages Indicates the status of database page validation.
Validating objects Indicates the status of table, materialized view, and index validation.
Backing up Indicates the progress of the backup.
Running post-backup Runs user-defined operations (if any were specified when the maintenance plan was created).
Terminating Re-enables new connections, and saves, discards, and emails report.

Create a maintenance plan report
View the maintenance plan report

Discuss this page in DocCommentXchange.