> ## 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.

# PAUSE SCHEDULES

The `PAUSE SCHEDULES` [statement](https://docs.cockroachlabs.com/docs/v24.2/sql-statements) can be used to pause [backup schedules](https://docs.cockroachlabs.com/docs/v24.2/create-schedule-for-backup) and [changefeed schedules](https://docs.cockroachlabs.com/docs/v24.2/create-schedule-for-changefeed).

After pausing a schedule, you can resume it with [`RESUME SCHEDULES`](https://docs.cockroachlabs.com/docs/v24.2/resume-schedules).

## Required privileges

The following users can pause a schedule:

* Members of the [`admin` role](https://docs.cockroachlabs.com/docs/v24.2/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/v24.2/create-schedule-for-backup).
* Owners of a changefeed schedule, i.e., the user that [created the changefeed schedule](https://docs.cockroachlabs.com/docs/v24.2/create-schedule-for-changefeed).

## Synopsis

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

## Parameters

| Parameter | Description |
| - | - |
| `selectclause` | A [selection query](https://docs.cockroachlabs.com/docs/v24.2/selection-queries) that returns `id`(s) to pause. |
| `scheduleID` | The `id` of the schedule you want to pause, which can be found with [`SHOW SCHEDULES`](https://docs.cockroachlabs.com/docs/v24.2/show-schedules). |

## Examples

### Pause a single schedule

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> PAUSE SCHEDULE 589963390487363585;
```

```
PAUSE SCHEDULES 1
```

### Pause multiple schedules

To pause multiple schedules, nest a [`SELECT` clause](https://docs.cockroachlabs.com/docs/v24.2/select-clause) that retrieves `id`(s) inside the `PAUSE SCHEDULES` statement:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> PAUSE SCHEDULES WITH x AS (SHOW SCHEDULES) SELECT id FROM x 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](https://docs.cockroachlabs.com/docs/v24.2/manage-a-backup-schedule)
* [`BACKUP`](https://docs.cockroachlabs.com/docs/v24.2/backup)
* [`RESTORE`](https://docs.cockroachlabs.com/docs/v24.2/restore)
* [`CREATE CHANGEFEED`](https://docs.cockroachlabs.com/docs/v24.2/create-changefeed)
* [`SHOW BACKUP`](https://docs.cockroachlabs.com/docs/v24.2/show-backup)
* [`SHOW SCHEDULES`](https://docs.cockroachlabs.com/docs/v24.2/show-schedules)
* [`RESUME SCHEDULES`](https://docs.cockroachlabs.com/docs/v24.2/resume-schedules)
* [`DROP SCHEDULES`](https://docs.cockroachlabs.com/docs/v24.2/drop-schedules)
* [`PAUSE JOB`](https://docs.cockroachlabs.com/docs/v24.2/pause-job)
* [`RESUME JOB`](https://docs.cockroachlabs.com/docs/v24.2/pause-job)
* [`CANCEL JOB`](https://docs.cockroachlabs.com/docs/v24.2/cancel-job)
* [Take Full and Incremental Backups](https://docs.cockroachlabs.com/docs/v24.2/take-full-and-incremental-backups)
* [Use the Built-in SQL Client](https://docs.cockroachlabs.com/docs/v24.2/cockroach-sql)
* [`cockroach` Commands Overview](https://docs.cockroachlabs.com/docs/v24.2/cockroach-commands)