------------------------------------------------------- -- Description : Displays scheduler job information. -- Requirements : Access to the DBA views. -- Call Syntax : @jobs ------------------------------------------------------
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