DROP JOB
Description
The user deletes a JOB job. The job will be stopped and deleted immediately.
Syntax
DROP JOB where jobName = <job_name> ;
Required parameters
1. <job_name>
The
<job_name>of the task to be deleted.
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 |
Examples
-
Delete the job named example.
DROP JOB where jobName='example';
