> ## Documentation Index
> Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# RESUME SCHEDULES
export const InternalLink = ({version, path = "", children, ...props}) => {
let detectedVersion = version || "stable";
if (typeof window !== 'undefined' && !version) {
const match = window.location.pathname.match(/\/docs\/([^/]+)/);
if (match) {
detectedVersion = match[1];
}
}
const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
return
{children}
;
};
The `RESUME SCHEDULES` statement can be used to resume paused schedules:
* Backup schedule
* Changefeed schedule
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 `admin` role. By default, the `root` user belongs to the `admin` role.
* 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
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> PAUSE SCHEDULE 589963390487363585;
```
```
PAUSE SCHEDULES 1
```
### Resume a single schedule
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> 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:
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> 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
* `BACKUP`
* `RESTORE`
* `SHOW BACKUP`
* `SHOW SCHEDULES`
* `PAUSE SCHEDULES`
* `DROP SCHEDULES`
* `PAUSE JOB`
* `RESUME JOB`
* `CANCEL JOB`
* Take Full and Incremental Backups
* Use the Built-in SQL Client
* `cockroach` Commands Overview