rem *********************************************************************
rem *                                                                   *
rem * Name      : jobs.sql                                              *
rem * Synopsis  : Shows status of DBMS jobs                             *
rem * Source    : http://www.oracle-dba.fr.pl                           *
rem *                                                                   *
rem *********************************************************************

column this_date        format a15
column next_date        format a15
column last_date        format a15
column what             format a60
column failures         format 999
column job              format 999
column hidden_last_date noprint

set linesize 1000
set pagesize 32000

break on hidden_last_date skip 1

select   job
,        to_char(last_date, 'DD-MON-YY HH24:MI') last_date
,        trunc(last_date)                        hidden_last_date
,        to_char(this_date, 'DD-MON-YY HH24:MI') this_date
,        to_char(next_date, 'DD-MON-YY HH24:MI') next_date
,        broken
,        failures
,        what
from     sys.dba_jobs
order by 2
/

column this_date        clear
column next_date        clear
column last_date        clear
column what             clear
column failures         clear
column job              clear
column hidden_last_date clear