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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database maintenance » Backup and data recovery » Backup and recovery plan design » Maintenance plans


Creating a maintenance plan

Create a maintenance plan by using Sybase Central.


To create a maintenance plan, you must have either the SELECT ANY TABLE system privilege or the SELECT privilege on the following tables:

  • dbo.maint_plan
  • dbo.maint_plan_report
  • dbo.maint_plan_status

You must also have the MANAGE ANY EVENT system privilege, and either the INSERT ANY TABLE system privilege or the INSERT privilege on the maint_plan table.

If you are running this task for the first time, or if the database has been upgraded since the last time the maintenance plans were accessed, you receive an error indicating that the maintenance plan tables must be created or updated. To create or update these tables, you must have the SELECT ANY TABLE system privilege, and either the CREATE ANY OBJECT system privilege or both the CREATE ANY INDEX and CREATE ANY TABLE system privileges. Click the Maintenance Plans folder to create or update the tables.

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the left pane, right-click Maintenance Plans and click New » Maintenance Plan.

  3. Follow the instructions in the wizard.


A maintenance plan is created.

 See also