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';