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 | ExecuteType | Notes |
|---|---|---|---|
| ADMIN_PRIV | Database | NO Streaming | Currently only supports ADMIN permissions to perform this operation |
| LOAD_PRIV | Database | Streaming | Supports LOAD permissions to perform this operation |
Example
-
Resume the job named example.
RESUME JOB where jobName= 'example';