On this page 
Warning:
Cockroach Labs will stop providing Assistance Support for v22.2 on June 5, 2024. Prior to that date, upgrade to a more recent version to continue receiving support. For more details, see 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?
