DROP SCHEDULES statement can be used to remove backup schedules or changefeed schedules.
When DROP SCHEDULES removes a full backup schedule, it removes the associated incremental backup schedule, if it exists.
DROP SCHEDULE does not cancel any in-progress jobs started by the schedule. Before you drop a schedule, cancel any in-progress jobs first, as you will not be able to look up the job ID once the schedule is dropped.Required privileges
The following users can drop a schedule:- Members of the
adminrole. By default, therootuser belongs to theadminrole. - Owners of a backup schedule, i.e., the user that created the backup schedule.
- Owners of a changefeed schedule, i.e., the user that created the changefeed schedule.
Synopsis
Parameters
Examples
Drop a schedule
Drop multiple schedules
To drop multiple schedules, nest aSELECT clause that retrieves id(s) inside the DROP SCHEDULES statement:
schedule_database are dropped.