Tuesday, June 3, 2014

Script to find in oracle 10g to Displays scheduler job information.

SET LINESIZE 200

COLUMN owner FORMAT A20
COLUMN next_run_date FORMAT A35

SELECT owner,
       job_name,
       enabled,
       job_class,
       next_run_date
FROM   dba_scheduler_jobs
ORDER BY owner, job_name;

No comments:

Post a Comment