Job details (<=9i)


<br />
SET LINESIZE 230<br />
SET PAGESIZE 9999<br />
SET VERIFY   OFF</p>
<p>COLUMN job        FORMAT 999   HEADING 'Job ID'<br />
COLUMN username   FORMAT a15   HEADING 'User'<br />
COLUMN what       FORMAT a30   HEADING 'What'<br />
COLUMN next_date  FORMAT a22   HEADING 'Next Run Date'<br />
COLUMN interval   FORMAT a30   HEADING 'Interval'<br />
COLUMN last_date  FORMAT a22   HEADING 'Last Run Date'<br />
COLUMN failures                HEADING 'Failures'<br />
COLUMN broken     FORMAT a7    HEADING 'Broken?'</p>
<p>SELECT<br />
    job<br />
  , log_user username<br />
  , what<br />
  , TO_CHAR(next_date, 'DD-MON-YYYY HH24:MI:SS') next_date<br />
  , interval<br />
  , TO_CHAR(last_date, 'DD-MON-YYYY HH24:MI:SS') last_date<br />
  , failures<br />
  , broken<br />
FROM<br />
    dba_jobs<br />
/<br />

SET LINESIZE 230
SET PAGESIZE 9999
SET VERIFY   OFF

COLUMN job        FORMAT 999   HEADING 'Job ID'
COLUMN username   FORMAT a15   HEADING 'User'
COLUMN what       FORMAT a30   HEADING 'What'
COLUMN next_date  FORMAT a22   HEADING 'Next Run Date'
COLUMN interval   FORMAT a30   HEADING 'Interval'
COLUMN last_date  FORMAT a22   HEADING 'Last Run Date'
COLUMN failures                HEADING 'Failures'
COLUMN broken     FORMAT a7    HEADING 'Broken?'

SELECT
    job
  , log_user username
  , what
  , TO_CHAR(next_date, 'DD-MON-YYYY HH24:MI:SS') next_date
  , interval
  , TO_CHAR(last_date, 'DD-MON-YYYY HH24:MI:SS') last_date
  , failures
  , broken
FROM
    dba_jobs
/