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:

• 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 pause.
scheduleID	The id of the schedule you want to pause, which can be found with .

Examples

Pause a single schedule

> PAUSE SCHEDULE 589963390487363585;

PAUSE SCHEDULES 1

Pause multiple schedules

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.

See also