jobs_details.sql | CHOUDHARI

-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 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;