RESUME SCHEDULES

On this page Carat arrow pointing down
Warning:
GA releases for CockroachDB v23.1 are no longer supported. Cockroach Labs will stop providing LTS Assistance Support for v23.1 LTS releases on November 13, 2025. Prior to that date, upgrade to a more recent version to continue receiving support. For more details, refer to the Release Support Policy.

The RESUME SCHEDULES statement can be used to resume paused schedules:

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:

Synopsis

RESUME SCHEDULE schedule_id SCHEDULES select_stmt

Parameters

Parameter Description
selectclause A selection query that returns id(s) to resume.
scheduleID The id of the schedule you want to resume, which can be found with SHOW SCHEDULES.

Examples

Pause a schedule

icon/buttons/copy
> PAUSE SCHEDULE 589963390487363585;
PAUSE SCHEDULES 1

Resume a single schedule

icon/buttons/copy
> RESUME SCHEDULE 589963390487363585;
RESUME SCHEDULES 1

Resume multiple schedules

To resume multiple schedules, nest a SELECT clause that retrieves id(s) inside the RESUME SCHEDULES statement:

icon/buttons/copy
> 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


Yes No
On this page

Yes No