8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Script: jobs.sql
( Download Script )
-- ----------------------------------------------------------------------------------- -- File Name : https://oracle-base.com/dba/10g/jobs.sql -- Author : Tim Hall -- Description : Displays scheduler job information. -- Requirements : Access to the DBA views. -- Call Syntax : @jobs -- Last Modified: 27/07/2005 -- ----------------------------------------------------------------------------------- SET LINESIZE 200 COLUMN owner FORMAT A20 COLUMN job_name FORMAT A30 COLUMN job_class FORMAT A30 COLUMN next_run_date FORMAT A36 SELECT owner, job_name, enabled, job_class, next_run_date FROM dba_scheduler_jobs ORDER BY owner, job_name;