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

# DROP SCHEDULES

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

When `DROP SCHEDULES` removes a [full backup schedule](https://docs.cockroachlabs.com/docs/v24.2/create-schedule-for-backup#create-a-schedule-for-full-backups-only), it removes the associated [incremental backup schedule](https://docs.cockroachlabs.com/docs/v24.2/create-schedule-for-backup#incremental-backup-schedules), if it exists.

> [!CAUTION]
>
> `DROP SCHEDULE` does **not** cancel any in-progress jobs started by the schedule. Before you drop a schedule, [cancel any in-progress jobs](https://docs.cockroachlabs.com/docs/v24.2/cancel-job) first, as you will not be able to look up the job ID once the schedule is dropped.

## Required privileges

The following users can drop 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

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

## Parameters

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

## Examples

### Drop a schedule

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

```
DROP SCHEDULES 1
```

### Drop multiple schedules

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

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> DROP SCHEDULES WITH x AS (SHOW SCHEDULES) SELECT id FROM x WHERE label = 'schedule_database';
```

```
DROP SCHEDULES 4
```

In this example, all schedules with the label `schedule_database` are dropped.

## 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)
* [`CREATE SCHEDULE FOR CHANGEFEED`](https://docs.cockroachlabs.com/docs/v24.2/create-schedule-for-changefeed)
* [`SHOW BACKUP`](https://docs.cockroachlabs.com/docs/v24.2/show-backup)
* [`SHOW SCHEDULES`](https://docs.cockroachlabs.com/docs/v24.2/show-schedules)
* [`PAUSE SCHEDULES`](https://docs.cockroachlabs.com/docs/v24.2/pause-schedules)
* [`RESUME SCHEDULES`](https://docs.cockroachlabs.com/docs/v24.2/resume-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)