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

SAP SQL Anywhere, on-demand edition 1.0 SP 6 » Task syntax

ApplyMaintenancePlan task

Applies a maintenance plan to a database.

Syntax 1 (SQL)
CALL DBCloud.ApplyMaintenancePlan ( plan=plan, database_list=database_list )
Syntax 2 (Cloud Command utility)
dbcloudcmd run ApplyMaintenancePlan plan database_list
Parameters
  • plan

    The plan to apply. Accepts a search query that identifies one plan, for example a plan name or ID. (Required)

  • database_list

    The target database(s). Accepts a search query that identifies databases. The search query can be a list of database names or database IDs separated with semicolons (;), or a full search. (Required)

Required privileges

BackupDatabase

Remarks

This task applies a maintenance plan to a database or group of databases. Existing backups are unaffected; however, all future backups follow the schedules in the specified plan.

Example

Run the following task to apply the maintenance plan called nightly to the database CustomerB:

dbcloudcmd run ApplyMaintenancePlan plan=nightly database_list=CustomerB

Run the following task to apply the maintenance plan called MyPlan to all running databases:

dbcloudcmd run ApplyMaintenancePlan MyPlan status:running