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 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';
schedule_database are dropped.
See also
