> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cockroachlabs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# RESUME SCHEDULES

The `RESUME SCHEDULES` [statement](https://docs.cockroachlabs.com/docs/stable/sql-statements.md) can be used to resume [paused schedules](https://docs.cockroachlabs.com/docs/stable/pause-schedules.md):

* [Backup schedule](https://docs.cockroachlabs.com/docs/stable/create-schedule-for-backup.md)
* [Changefeed schedule](https://docs.cockroachlabs.com/docs/stable/create-schedule-for-changefeed.md)

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](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization#default-roles). By default, the `root` user belongs to the `admin` role.
* Owners of a backup schedule, i.e., the user that [created the backup schedule](https://docs.cockroachlabs.com/docs/stable/create-schedule-for-backup.md).
* Owners of a changefeed schedule, i.e., the user that [created the changefeed schedule](https://docs.cockroachlabs.com/docs/stable/create-schedule-for-changefeed.md).

## Synopsis

![resume\_schedule syntax diagram](https://mintcdn.com/cockroachlabs/UZNSFbmU2EwEm6G5/images/sql-diagrams/common/resume_schedule.svg?fit=max\&auto=format\&n=UZNSFbmU2EwEm6G5\&q=85\&s=0f04ae4d0adb325d8f9a4d8d8f09116f)

## Parameters

| Parameter | Description |
| - | - |
| `selectclause` | A [selection query](https://docs.cockroachlabs.com/docs/stable/selection-queries.md) that returns `id`(s) to resume. |
| `scheduleID` | The `id` of the schedule you want to resume, which can be found with [`SHOW SCHEDULES`](https://docs.cockroachlabs.com/docs/stable/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](https://docs.cockroachlabs.com/docs/stable/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](https://docs.cockroachlabs.com/docs/stable/manage-a-backup-schedule.md)
* [`BACKUP`](https://docs.cockroachlabs.com/docs/stable/backup)
* [`RESTORE`](https://docs.cockroachlabs.com/docs/stable/restore)
* [`SHOW BACKUP`](https://docs.cockroachlabs.com/docs/stable/show-backup)
* [`SHOW SCHEDULES`](https://docs.cockroachlabs.com/docs/stable/show-schedules)
* [`PAUSE SCHEDULES`](https://docs.cockroachlabs.com/docs/stable/pause-schedules)
* [`DROP SCHEDULES`](https://docs.cockroachlabs.com/docs/stable/drop-schedules)
* [`PAUSE JOB`](https://docs.cockroachlabs.com/docs/stable/pause-job)
* [`RESUME JOB`](https://docs.cockroachlabs.com/docs/stable/pause-job)
* [`CANCEL JOB`](https://docs.cockroachlabs.com/docs/stable/cancel-job)
* [Take Full and Incremental Backups](https://docs.cockroachlabs.com/docs/stable/take-full-and-incremental-backups.md)
* [Use the Built-in SQL Client](https://docs.cockroachlabs.com/docs/stable/cockroach-sql.md)
* [`cockroach` Commands Overview](https://docs.cockroachlabs.com/docs/stable/cockroach-commands)