RESUME SCHEDULES

On this page

The RESUME SCHEDULES statement can be used to resume paused backup 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:

Members of the admin role. By default, the root user belongs to the admin role.
New in v22.2: Owners of a backup schedule, i.e., the user that created the backup schedule.

Synopsis

RESUME SCHEDULES <selectclause>
 selectclause: select statement returning schedule IDs to resume.

RESUME SCHEDULE <scheduleID>

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

> PAUSE SCHEDULE 589963390487363585;

PAUSE SCHEDULES 1

Resume a single schedule

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

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

Pricing

Contact us

Sign In