← 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