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:
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.
Connect to your database from Sybase Central.
Open the Maintenance Plans folder for the database.
From the File menu, choose New > Maintenance Plan.
The Create Maintenance Plan wizard appears.
Follow the instructions in the wizard.
For more information about the available settings, see:
Once the maintenance plan has been executed, connect to your database from Sybase Central.
Open the Maintenance Plans folder.
Double-click your maintenance plan.
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.