On this page 
Warning:
CockroachDB v22.2 is no longer supported as of June 5, 2024. For more details, refer to the Release Support Policy.
The DROP SCHEDULES statement can be used to remove backup schedules.
Warning:
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. - New in v22.2: Owners of a backup schedule, i.e., the user that created the backup schedule.
Synopsis
DROP SCHEDULES <selectclause>
select clause: select statement returning schedule id to pause.
DROP SCHEDULE <scheduleID>
Parameters
| Parameter | Description |
|---|---|
selectclause |
A selection query that returns id(s) to drop. |
scheduleID |
The id of the schedule you want to drop, which can be found with SHOW SCHEDULES. |
Examples
Drop a schedule
> DROP SCHEDULE 589963390487363585;
DROP SCHEDULES 1
Drop multiple schedules
To drop multiple schedules, nest a SELECT clause that retrieves id(s) inside the DROP SCHEDULES statement:
> DROP SCHEDULES WITH x AS (SHOW SCHEDULES) SELECT id FROM x WHERE label = 'schedule_database';
DROP SCHEDULES 4
In this example, all schedules with the label schedule_database are dropped.
See also
- Manage a Backup Schedule
BACKUPRESTORESHOW BACKUPSHOW SCHEDULESPAUSE SCHEDULESRESUME SCHEDULESPAUSE JOBRESUME JOBCANCEL JOB- Take Full and Incremental Backups
- Use the Built-in SQL Client
cockroachCommands Overview
Was this helpful?
