DISABLE

The DISABLE procedure disables programs and jobs.

When a Scheduler object is disabled, its enabled attribute is set to FALSE.

Syntax

DBMS_SCHEDULER.DISABLE (
job_name              IN VARCHAR2,
force                 IN BOOLEAN DEFAULT FALSE,
commit_semantics      IN VARCHAR2 DEFAULT 'STOP_ON_FIRST_ERROR');

Parameters

Considerations

Disabling an already disabled object does not result in an error.

The force option identifies dependencies without altering the dependent objects.

Disabling a job means that, although the job's metadata exists, it should not be processed or executed. When a job is disabled, its state in the job queue changes to disabled. If force is set to FALSE and the job is currently running, an error is returned. If force is set to TRUE, the job will be disabled, but the currently running instance is allowed to complete.

When a program is disabled, its status becomes disabled. A disabled program means that, although the metadata still exists, any jobs pointing to it cannot run. If force is set to FALSE, no jobs can reference the program; otherwise, an error will occur. If force is set to TRUE, jobs pointing to the program will not be disabled because their program becomes invalid, and they will fail. Running jobs pointing to the program are not affected by the DISABLE call and can continue running. When a program is disabled, the parameters related to the program are not affected.

Examples

-- View all jobs (requires DBA privileges)
SELECT JOB, LOG_USER, WHAT, NEXT_DATE, INTERVAL, BROKEN, FAILURES
FROM DBA_JOBS;

BEGIN
  SYS.DBMS_SCHEDULER.DISABLE(
            job_name => 'empprogram',
            force => TRUE,
            COMMIT_SEMANTICS => 'STOP_ON_FIRST_ERROR');
END;