On this page
The PAUSE JOB statement lets you resume paused jobs, which can be either enterprise BACKUP or RESTORE jobs.
Note:
As of v1.1, you cannot pause schema changes or 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 resume, which can be found with SHOW JOBS. |
Examples
Pause & Resume a Restore Job
> SHOW JOBS;
+----------------+---------+-------------------------------------------+...
| id | type | description |...
+----------------+---------+-------------------------------------------+...
| 27536791415282 | RESTORE | RESTORE db.* FROM 'azure://backup/db/tbl' |...
+----------------+---------+-------------------------------------------+...
> PAUSE JOB 27536791415282;
Once you're ready for the restore to resume:
> RESUME JOB 27536791415282;