The RESUME JOB statement lets you resume the following types of jobs:

Required privileges

To resume a job, the user must be a member of the admin role or must have the CONTROLJOB parameter set.

Synopsis

RESUME JOB job_id JOBS select_stmt for_schedules_clause

Parameters

Parameter Description
job_id The ID of the job you want to resume, which can be found with SHOW JOBS.
select_stmt A selection query that returns job_id(s) to resume.
for_schedules_clause New in v20.2: The schedule you want to resume jobs for. You can resume jobs for a specific schedule (FOR SCHEDULE id) or resume jobs for multiple schedules by nesting a SELECT clause in the statement (FOR SCHEDULES <select_clause>). See the examples below.

Examples

Pause a job

copy
icon/buttons/copy
> SHOW JOBS;
+----------------+---------+-------------------------------------------+...
|       id       |  type   |               description                 |...
+----------------+---------+-------------------------------------------+...
| 27536791415282 | RESTORE | RESTORE db.* FROM 'azure://backup/db/tbl' |...
+----------------+---------+-------------------------------------------+...
copy
icon/buttons/copy
> PAUSE JOB 27536791415282;

Resume a single job

copy
icon/buttons/copy
> RESUME JOB 27536791415282;

Resume multiple jobs

To resume multiple jobs, nest a SELECT clause that retrieves job_id(s) inside the RESUME JOBS statement:

copy
icon/buttons/copy
> RESUME JOBS (SELECT job_id FROM [SHOW JOBS]
      WHERE user_name = 'maxroach');

All jobs created by maxroach will be resumed.

Resume jobs for a schedule

New in v20.2: To resume jobs for a specific backup schedule, use the schedule's id:

copy
icon/buttons/copy
> RESUME JOBS FOR SCHEDULE 590204387299262465;
RESUME JOBS FOR SCHEDULES 1

You can also resume multiple schedules by nesting a SELECT clause that retrieves id(s) inside the PAUSE JOBS statement:

copy
icon/buttons/copy
> RESUME JOBS FOR SCHEDULES SELECT id FROM [SHOW SCHEDULES] WHERE label = 'test_schedule';
RESUME JOBS FOR SCHEDULES 2

See also



Yes No