On this page
Warning:
As of May 16, 2023, CockroachDB v21.2 is no longer supported. 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
> 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 SELECT
clause that retrieves id
(s) inside the RESUME SCHEDULES
statement:
> RESUME SCHEDULES SELECT id FROM [SHOW SCHEDULES] WHERE label = 'schedule_database';
RESUME SCHEDULES 4
All schedules with the label schedule_database
are resumed.