PAUSE SCHEDULES

On this page Carat arrow pointing down

The PAUSE SCHEDULES statement can be used to pause backup schedules.

After pausing a schedule, you can resume it with RESUME SCHEDULES.

Required privileges

The following users can pause a schedule:

Synopsis

PAUSE SCHEDULES <selectclause>
  select clause: select statement returning schedule id to pause.
PAUSE SCHEDULE <scheduleID>

Parameters

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

Examples

Pause a single schedule

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

Pause multiple schedules

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

icon/buttons/copy
> PAUSE SCHEDULES WITH x AS (SHOW SCHEDULES) SELECT id FROM x WHERE label = 'schedule_database';
PAUSE SCHEDULES 4

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

See also


Yes No
On this page

Yes No