Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

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 on a database:

• validating the database
• backing up the database
• managing the maintenance log

You create a maintenance plan from Sybase Central using the Create Maintenance Plan wizard. Each time the maintenance plan runs, a maintenance report is saved in the database. You can view this report from Sybase Central, or you can have the maintenance log emailed to you after each time the maintenance plan executes on the database.

To create a maintenance plan

1. Connect to your database from Sybase Central.

2. Open the Maintenance Plans folder for the database.

3. From the File menu, choose New > Maintenance Plan.

   The Create Maintenance Plan wizard appears.

4. Follow the instructions in the wizard.

   For more information about the available settings, see:

   • Defining schedules
   • VALIDATE statement
   • Types of backup
   • xp_startsmtp system procedure

To view the maintenance report

1. Once the maintenance plan has been executed, connect to your database from Sybase Central.

2. Open the Maintenance Plans folder.

3. Double-click your maintenance plan.

4. Double-click the report on the Reports tab in the right pane.

   The Maintenance Plan property sheet appears. The Details pane contains the log for the maintenance plan.