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

# Schedules Page

The **Schedules** page of the DB Console provides details about the scheduled tasks performed by your cluster. These can include:

* [Scheduled backups](https://docs.cockroachlabs.com/docs/stable/manage-a-backup-schedule.md)
* [Scheduled auto statistics compaction](https://docs.cockroachlabs.com/docs/stable/cost-based-optimizer.md#table-statistics)
* [Row-level TTL](https://docs.cockroachlabs.com/docs/stable/row-level-ttl.md)

To view these details, [access the DB console](https://docs.cockroachlabs.com/docs/stable/ui-overview.md#db-console-access) and click **Schedules** in the left-hand navigation.

## Required privileges

To view the **Schedules** page, a user must be a member of the [`admin` role](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization#admin-role) or have the [`VIEWJOB`](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization#viewjob) system privilege. To grant this privilege:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
GRANT SYSTEM VIEWJOB TO <user>;
```

Without sufficient privileges, the Schedules page displays an error message.

## Filter schedules

* Use the **Status** menu to filter schedules by schedule status, displaying all schedules, only active schedules, or only paused schedules.
* Use the **Show** menu to toggle displaying the latest 50 schedules or all schedules on the cluster.

## Schedules list

Use the **Schedules** list to see your active and paused schedules.

* To view schedule details click the schedule ID.
* If you drop a schedule, it will no longer be listed.

The following screenshot shows a list of backups and automated statistics compaction schedules:

![Schedules Page UI in the DB Console showing a list of schedules](https://mintcdn.com/cockroachlabs/iiBVxthghoAOO3UM/images/common/schedules-page.png?fit=max\&auto=format\&n=iiBVxthghoAOO3UM\&q=85\&s=3f94090794fb9930a19ef558857844a4)

| Column | Description |
| - | - |
| Schedule ID | The unique ID for the schedule. This is used to [pause](https://docs.cockroachlabs.com/docs/stable/pause-schedules.md), [resume](https://docs.cockroachlabs.com/docs/stable/resume-schedules.md), and [drop](https://docs.cockroachlabs.com/docs/stable/drop-schedules.md) schedules. |
| Label | The label given to the schedule on creation. |
| Status | The current status of the schedule, **Active** or **Paused**. |
| Next Execution Time (UTC) | The next time at which the scheduled task will run. |
| Recurrence | How often the schedule will run. |
| Jobs Running | The number of jobs currently running for that schedule. |
| Owner | The user that created the schedule. |
| Creation Time (UTC) | The time at which the user originally created the schedule. |

## Schedule details

Click on a schedule ID to view the full SQL statement that the schedule runs. For example, the following screenshot shows the resulting [`BACKUP`](https://docs.cockroachlabs.com/docs/stable/backup) statement for a full cluster backup recurring every day:

![UI for each individual schedule ID displaying the CREATE SCHEDULE SQL statement](https://mintcdn.com/cockroachlabs/iiBVxthghoAOO3UM/images/common/schedule-id-screen.png?fit=max\&auto=format\&n=iiBVxthghoAOO3UM\&q=85\&s=9e2c683e718b62f2546107ab8f14be0f)

You may also view a `protected_timestamp_record` on this page. This indicates that the schedule is actively managing its own [protected timestamp](https://docs.cockroachlabs.com/docs/stable/architecture/storage-layer.md#protected-timestamps) records independently of [GC TTL](https://docs.cockroachlabs.com/docs/stable/configure-replication-zones.md#gc-ttlseconds). See [Protected timestamps and scheduled backups](https://docs.cockroachlabs.com/docs/stable/create-schedule-for-backup.md#protected-timestamps-and-scheduled-backups) for more detail.

## See also

* [`CREATE SCHEDULE FOR BACKUP`](https://docs.cockroachlabs.com/docs/stable/create-schedule-for-backup)
* [Take Full and Incremental Backups](https://docs.cockroachlabs.com/docs/stable/take-full-and-incremental-backups.md)