On this page 
New in v20.2: The PAUSE SCHEDULES statement can be used to pause backup schedules.
After pausing a schedule, you can resume it with RESUME SCHEDULES.
Required privileges
Only members of the admin role can pause a schedule. By default, the root user belongs to the admin role.
Synopsis
PAUSE SCHEDULES <selectclause>
select clause: select statement returning schedule id to pause.
PAUSE SCHEDULE <scheduleID>
Parameters
| Parameter | Description |
|---|---|
selectclause |
A selection query that returns id(s) to pause. |
scheduleID |
The id of the schedule you want to pause, which can be found with SHOW SCHEDULES. |
Examples
Pause a single schedule
> PAUSE SCHEDULE 589963390487363585;
PAUSE SCHEDULES 1
Pause multiple schedules
To pause multiple schedules, nest a SELECT clause that retrieves id(s) inside the PAUSE SCHEDULES statement:
> PAUSE SCHEDULES SELECT id FROM [SHOW SCHEDULES] WHERE label = 'schedule_database';
PAUSE SCHEDULES 4
In this example, all schedules with the label schedule_database are paused.
See also
- Manage a Backup Schedule
BACKUPRESTORESHOW BACKUPSHOW SCHEDULESRESUME SCHEDULESDROP SCHEDULESPAUSE JOBRESUME JOBCANCEL JOB- Take Full and Incremental Backups
- Use the Built-in SQL Client
- Other Cockroach Commands
Was this helpful?
