On this page
Warning:
As of May 10, 2022, CockroachDB v20.2 is no longer supported. For more details, refer to the Release Support Policy.
New in v20.2: 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.