The REMOVE procedure is used to remove an existing job from the job queue. It does not stop a running job.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
DBMS_JOB.REMOVE (
job IN BINARY_INTEGER );
Parameters
| Parameter | Description |
|---|---|
| job | The unique ID of the job to be modified. To find this ID, query the JOB column of the USER_JOBS or DBA_JOBS view. |
Considerations
Before submission, the job will not be processed by the background job queue.
Examples
BEGIN
DBMS_JOB.REMOVE(10100);
COMMIT;
END;