On this page 
Warning:
As of June 5, 2024, CockroachDB v22.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
The following users can resume a schedule:
- Members of the
adminrole. By default, therootuser belongs to theadminrole. - New in v22.2: Owners of a backup schedule, i.e., the user that created the backup schedule.
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 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
- Manage a Backup Schedule
BACKUPRESTORESHOW BACKUPSHOW SCHEDULESPAUSE SCHEDULESDROP SCHEDULESPAUSE JOBRESUME JOBCANCEL JOB- Take Full and Incremental Backups
- Use the Built-in SQL Client
cockroachCommands Overview
Was this helpful?
