RESUME SCHEDULES

On this page Carat arrow pointing down
Warning:
CockroachDB v21.2 is no longer supported as of May 16, 2023. For more details, refer to the Release Support Policy.

The RESUME SCHEDULES statement can be used to resume paused backup schedules. When a schedule is resumed, the next_run will be set to the next TIMESTAMP that conforms to the schedule.

Required privileges

Only members of the admin role can resume a schedule. By default, the root user belongs to the admin role.

Synopsis

RESUME SCHEDULES <selectclause>
 selectclause: select statement returning schedule IDs to resume.

RESUME SCHEDULE <scheduleID>

Parameters

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

Examples

Pause a schedule

icon/buttons/copy
> PAUSE SCHEDULE 589963390487363585;
PAUSE SCHEDULES 1

Resume a single schedule

icon/buttons/copy
> RESUME SCHEDULE 589963390487363585;
RESUME SCHEDULES 1

Resume multiple schedules

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

icon/buttons/copy
> RESUME SCHEDULES SELECT id FROM [SHOW SCHEDULES] WHERE label = 'schedule_database';
RESUME SCHEDULES 4

All schedules with the label schedule_database are resumed.

See also


Yes No
On this page

Yes No