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.
To create a maintenance plan
Connect to the database as a user with DBA authority.
In the left pane, right-click Maintenance Plans and choose New » Maintenance Plan.
Follow the instructions in the Create Maintenance Plan Wizard.
For more information about the available settings, see:
To view the maintenance report
After the maintenance plan is executed, connect to the database as a user with DBA authority.
In the left pane, double-click Maintenance Plans.
Double-click your maintenance plan.
In the right pane, double-click the report.
The Maintenance Plan Properties window appears. The Details pane contains the log for the maintenance plan.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|