← Scheduler & Jobs
Oracle · Scheduler & Jobs
How to drop a scheduler job in Oracle
Permanently remove a scheduler job with DBMS_SCHEDULER.DROP_JOB, including the force option, and confirm removal.
Tested on11g12c18c19c21c23ai26ai
Permanently remove a Scheduler job.
This deletes the job and cannot be undone. force => TRUE drops it even if it is running (the job is stopped first).
BEGIN
DBMS_SCHEDULER.DROP_JOB(
job_name => '&&job_name',
force => TRUE);
END;
/
-- Verify (read-only): no rows once dropped
SELECT job_name
FROM dba_scheduler_jobs
WHERE job_name = UPPER('&job_name');DBMS_SCHEDULERDROP_JOBScheduler