On this page 
The RESUME JOB statement lets you resume paused IMPORT jobs, enterprise BACKUP and RESTORE jobs, and, as of v2.1, changefeeds.
Note:
You cannot pause schema changes.Required privileges
By default, only the root user can control a job.
Synopsis
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. |
Examples
Pause a job
> SHOW JOBS;
+----------------+---------+-------------------------------------------+...
| id | type | description |...
+----------------+---------+-------------------------------------------+...
| 27536791415282 | RESTORE | RESTORE db.* FROM 'azure://backup/db/tbl' |...
+----------------+---------+-------------------------------------------+...
> PAUSE JOB 27536791415282;
Resume a single job
> RESUME JOB 27536791415282;
Resume multiple jobs
New in v2.1: To resume multiple jobs, nest a SELECT clause that retrieves job_id(s) inside the RESUME JOBS statement:
> RESUME JOBS (SELECT job_id FROM [SHOW JOBS]
WHERE user_name = 'maxroach');
All jobs created by maxroach will be resumed.
See also
Was this helpful?
