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

# Schedules Page

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 <a href={`/docs/${detectedVersion}/${normalizedPath}`} {...props}>
      {children}
    </a>;
};

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

* <InternalLink path="manage-a-backup-schedule">Scheduled backups</InternalLink>
* <InternalLink path="cost-based-optimizer#table-statistics">Scheduled auto statistics compaction</InternalLink>
* <InternalLink path="row-level-ttl">Row-level TTL</InternalLink>

To view these details, <InternalLink path="ui-overview#db-console-access">access the DB console</InternalLink> and click **Schedules** in the left-hand navigation.

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

<img src="https://mintcdn.com/cockroachlabs/mWJHSqov-YrcB8t4/images/v25.4/schedules-page.png?fit=max&auto=format&n=mWJHSqov-YrcB8t4&q=85&s=93bc90a2c5a2a99646fd1fd9533d29ff" alt="Schedules Page UI in the DB Console showing a list of schedules" width="1978" height="778" data-path="images/v25.4/schedules-page.png" />

| Column                    | Description                                                                                                                                                                                                                                    |
| ------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Schedule ID               | The unique ID for the schedule. This is used to <InternalLink path="pause-schedules">pause</InternalLink>, <InternalLink path="resume-schedules">resume</InternalLink>, and <InternalLink path="drop-schedules">drop</InternalLink> 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 <InternalLink path="backup">`BACKUP`</InternalLink> statement for a full cluster backup recurring every day:

<img src="https://mintcdn.com/cockroachlabs/mWJHSqov-YrcB8t4/images/v25.4/schedule-id-screen.png?fit=max&auto=format&n=mWJHSqov-YrcB8t4&q=85&s=628dfc35c4b6b7f0932269eb806e2a77" alt="UI for each individual schedule ID displaying the CREATE SCHEDULE SQL statement" width="1884" height="613" data-path="images/v25.4/schedule-id-screen.png" />

You may also view a `protected_timestamp_record` on this page. This indicates that the schedule is actively managing its own <InternalLink path="architecture/storage-layer#protected-timestamps">protected timestamp</InternalLink> records independently of <InternalLink path="configure-replication-zones">GC TTL</InternalLink>. See <InternalLink path="create-schedule-for-backup#protected-timestamps-and-scheduled-backups">Protected timestamps and scheduled backups</InternalLink> for more detail.

## See also

* <InternalLink path="create-schedule-for-backup">`CREATE SCHEDULE FOR BACKUP`</InternalLink>
* <InternalLink path="take-full-and-incremental-backups">Take Full and Incremental Backups</InternalLink>
