RESUME SCHEDULES

The RESUME SCHEDULES can be used to resume :

When a schedule is resumed, the next_run will be set to the next TIMESTAMP that conforms to the schedule.

Required privileges

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

Examples

Pause a schedule

> PAUSE SCHEDULE 589963390487363585;

PAUSE SCHEDULES 1

Resume a single schedule

> RESUME SCHEDULE 589963390487363585;

RESUME SCHEDULES 1

Resume multiple schedules

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

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

RESUME SCHEDULES 4

All schedules with the label schedule_database are resumed.

See also