rem *********************************************************************
rem * Copyright © Oracle-Consultant.co.uk 2001, all rights reserved     *
rem *                                                                   *
rem * Name      : jobs.sql                                              *
rem * Synopsis  : Shows status of DBMS jobs                             *
rem * Source    : http://www.oracle-consultant.co.uk                    *
rem *                                                                   *
rem * Oracle-Consultant.co.uk are not responsible for any liability     *
rem * that may arise from the use of this code. Support can be obtained *
rem * by emailing script_support@oracle-consultant.co.uk                *
rem * Note: This script is best viewed in a fixed-width font.           *
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