RESUME JOB
Descriptionβ
Restore the PAUSED job to the RUNNING state. The RUNNING job will be executed according to the scheduled period.
Syntaxβ
RESUME JOB where jobName = <job_name> ;
Required parametersβ
1. <job_name>
The
<job_name>
of the recovery task.
Access Control Requirementsβ
The user who executes this SQL command must have at least the following permissions:
Privilege | Object | Notes |
---|---|---|
ADMIN_PRIV | Database | Currently only supports ADMIN permissions to perform this operation |
Exampleβ
-
Resume the job named example.
RESUME JOB where jobName= 'example';