How to enable or disable a scheduler job in Oracle

Disable a Scheduler job to stop it running on schedule, or enable it again.

Disabling stops future runs. force => TRUE lets you disable even when the job is running or has dependents.

-- Disable
BEGIN
  DBMS_SCHEDULER.DISABLE(name => '&&job_name', force => TRUE);
END;
/

-- Enable
BEGIN
  DBMS_SCHEDULER.ENABLE(name => '&job_name');
END;
/

-- Verify (read-only)
SELECT job_name, enabled, state
FROM   dba_scheduler_jobs
WHERE  job_name = UPPER('&job_name');