VIEW: SYS.DBA_JOBS

Source

View Text - Preformatted

select JOB, lowner LOG_USER, powner PRIV_USER, cowner SCHEMA_USER,
    LAST_DATE, substr(to_char(last_date,'HH24:MI:SS'),1,8) LAST_SEC,
    THIS_DATE, substr(to_char(this_date,'HH24:MI:SS'),1,8) THIS_SEC,
    NEXT_DATE, substr(to_char(next_date,'HH24:MI:SS'),1,8) NEXT_SEC,
    (total+(sysdate-nvl(this_date,sysdate)))*86400 TOTAL_TIME,
    decode(mod(FLAG,2),1,'Y',0,'N','?') BROKEN,
    INTERVAL# interval, FAILURES, WHAT,
    nlsenv NLS_ENV, env MISC_ENV, j.field1 INSTANCE
  from sys.job$ j
  where BITAND(j.scheduler_flags, 2) IS NULL OR
        BITAND(j.scheduler_flags, 2) = 0 /* don't show jobs with drop flag */

View Text - HTML Formatted

SELECT JOB
, LOWNER LOG_USER
, POWNER PRIV_USER
, COWNER SCHEMA_USER
, LAST_DATE
, SUBSTR(TO_CHAR(LAST_DATE
, 'HH24:MI:SS')
, 1
, 8) LAST_SEC
, THIS_DATE
, SUBSTR(TO_CHAR(THIS_DATE
, 'HH24:MI:SS')
, 1
, 8) THIS_SEC
, NEXT_DATE
, SUBSTR(TO_CHAR(NEXT_DATE
, 'HH24:MI:SS')
, 1
, 8) NEXT_SEC
, (TOTAL+(SYSDATE-NVL(THIS_DATE
, SYSDATE)))*86400 TOTAL_TIME
, DECODE(MOD(FLAG
, 2)
, 1
, 'Y'
, 0
, 'N'
, '?') BROKEN
, INTERVAL# INTERVAL
, FAILURES
, WHAT
, NLSENV NLS_ENV
, ENV MISC_ENV
, J.FIELD1 INSTANCE
FROM SYS.JOB$ J
WHERE BITAND(J.SCHEDULER_FLAGS
, 2) IS NULL OR BITAND(J.SCHEDULER_FLAGS
, 2) = 0 /* DON'T SHOW JOBS WITH DROP FLAG */