@/u01/dba/oraschedjobstatus.sql
@/u01/dba/oraschedjobstatusbyjobname.sql
@/u01/dba/oraschedjobhistory.sql
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
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.
EXEC dbms_scheduler.enable('&OWNER.JOB');
EXEC dbms_scheduler.stop_job('"&OWNER"."&JOB"');
EXEC dbms_scheduler.disable('"&OWNER"."&JOB"');
@/u01/dba/orascheddisablealljobs.sql
@/tmp/tmporascheddisablealljobs.sql
@/u01/dba/orascheddisablealljobsbyowners.sql
@/tmp/tmporascheddisablealljobsbyowners.sql