PAUSE SCHEDULES

The PAUSE SCHEDULES can be used to pause and . After pausing a schedule, you can resume it with .

Required privileges

The following users can pause a schedule:

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

> PAUSE SCHEDULE 589963390487363585;

PAUSE SCHEDULES 1

To pause multiple schedules, nest a that retrieves id(s) inside the PAUSE SCHEDULES statement:

> PAUSE SCHEDULES WITH x AS (SHOW SCHEDULES) SELECT id FROM x WHERE label = 'schedule_database';

PAUSE SCHEDULES 4

In this example, all schedules with the label schedule_database are paused.