DROP SCHEDULES

The DROP SCHEDULES can be used to remove or .

When DROP SCHEDULES removes a , it removes the associated , if it exists.

DROP SCHEDULE does not cancel any in-progress jobs started by the schedule. Before you drop a schedule, 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 . By default, the root user belongs to the admin role.
• Owners of a backup schedule, i.e., the user that .
• Owners of a changefeed schedule, i.e., the user that .

Synopsis

Parameters

Parameter	Description
selectclause	A that returns id(s) to drop.
scheduleID	The id of the schedule you want to drop, which can be found with .

Examples

Drop a schedule

> DROP SCHEDULE 589963390487363585;

DROP SCHEDULES 1

Drop multiple schedules

To drop multiple schedules, nest a 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