Oracle Scheduler 

DBMS_SCHEDULER

Check Job Status

@/u01/dba/oraschedjobstatus.sql

@/u01/dba/oraschedjobstatusbyjobname.sql

Check Job History

@/u01/dba/oraschedjobhistory.sql

Check Job Definition

You can use DBMS_METADATA to extract the job definition DDL...

&MYJOBNAME and &MYSCHEMA should match the output from the Job Status script above.

@/u01/dba/oraschedjobdef.sql

Enabling/Disabling Jobs

To prevent a job running (without removing it's definition) you should disable it. To reinstate the job schedule you should then enable it again.

Enable a job

EXEC dbms_scheduler.enable('&OWNER.JOB');

Stop a running job

EXEC dbms_scheduler.stop_job('"&OWNER"."&JOB"');

Disable a job

NOTE: Double Quotes are necessary where the name is in mixed case.

EXEC dbms_scheduler.disable('"&OWNER"."&JOB"');

Disable All Jobs

@/u01/dba/orascheddisablealljobs.sql 

@/tmp/tmporascheddisablealljobs.sql

Disable ALL Jobs for a specified Owner

@/u01/dba/orascheddisablealljobsbyowners.sql 

@/tmp/tmporascheddisablealljobsbyowners.sql 

Bibliography