The REMOVE stored procedure removes a job from the job queue, without stopping running jobs.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_JOB.REMOVE (
job IN BINARY_INTEGER );
Parameters
| Parameter | Description |
|---|---|
| job | The unique ID of the job to be modified. You can query this ID from the JOB column of the USER_JOBS or DBA_JOBS view. |
Considerations
Before a job is submitted, it cannot be handled by the job queue in the background.
Examples
BEGIN
DBMS_JOB.REMOVE(10100);
COMMIT;
END;