DROP SCHEDULES

On this page Carat arrow pointing down
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:

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

icon/buttons/copy
> 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:

icon/buttons/copy
> 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


Yes No
On this page

Yes No