On this page 
New in v1.1: The PAUSE JOB statement lets you pause enterprise BACKUP and RESTORE jobs.
After pausing jobs, you can resume them with RESUME JOB.
Note:
As of v1.1, you cannot pause schema changes or enterprise IMPORT jobs.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 pause, which can be found with SHOW JOBS. |
Examples
Pause a Restore Job
> SHOW JOBS;
+----------------+---------+-------------------------------------------+...
| id | type | description |...
+----------------+---------+-------------------------------------------+...
| 27536791415282 | RESTORE | RESTORE db.* FROM 'azure://backup/db/tbl' |...
+----------------+---------+-------------------------------------------+...
> PAUSE JOB 27536791415282;
See Also
Was this helpful?
