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:
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.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, right-click Maintenance Plans and click New » Maintenance Plan.
Follow the instructions in the wizard.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|