The DROP_JOB procedure is used to delete one or more jobs or all jobs in one or more job classes. When a job is deleted, all parameter values set for the job are also deleted.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
DBMS_SCHEDULER.DROP_JOB (
job_name IN VARCHAR2,
force IN BOOLEAN DEFAULT FALSE,
defer IN BOOLEAN DEFAULT FALSE,
commit_semantics IN VARCHAR2 DEFAULT 'null');
Parameters
| Parameter | Description |
|---|---|
| job_name | The name of the job or job class. The name can be a comma-separated list. For a job class, specify the SYS schema. If the name of a job class is specified, the jobs in the job class are deleted, but the job class itself is not deleted. |
| force | If set to TRUE, the scheduler will first attempt to stop the running job instance before deleting the job. |
| defer | If set to TRUE, the scheduler will first attempt to allow the running job to complete its execution before deleting the job. |
| commit_semantics | The commit semantics. Valid values:
|
Examples
BEGIN
DBMS_SCHEDULER.DROP_JOB(job_name => 'job_test');
END;