On this page 
Warning:
GA releases for CockroachDB v23.1 are no longer supported. Cockroach Labs will stop providing LTS Assistance Support for v23.1 LTS releases on November 13, 2025. Prior to that date, upgrade to a more recent version to continue receiving support. For more details, refer to the Release Support Policy.
The RESUME SCHEDULES statement can be used to resume paused 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. - Owners of a backup schedule, i.e., the user that created the backup schedule.
- Owners of a changefeed schedule, i.e., the user that created the changefeed schedule.
Synopsis
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?
