-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -- Author : Sameer S Choudhari -- Description : Describes all jobs in the database. -- Call Syntax : @jobs_details.sql -- Last Modified: 30/06/2016 -- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ SET LINES 220 PAGES 49999 ALTER SESSION SET nls_date_format='DD-MON-YYYY HH24:MI:SS'; COLUMN schema_user FORMAT a20 COLUMN broken FORMAT a10 COLUMN interval FORMAT a40 COLUMN what FORMAT a70 SELECT job, schema_user, last_date, next_date, total_time, broken, interval, what FROM dba_jobs ORDER BY job;