jobs.sql

rem -----------------------------------------------------------------------
rem Filename:   jobs.sql
rem Purpose:    Returns information about jobs in the job queue.
rem Author:     cdye@excitecorp.com
rem Date:       31-Jul-1996
rem -----------------------------------------------------------------------
column JOB              heading "Job"           format 9999
column LAST_DATE        heading "Last Date"     format a20
column NEXT_DATE        heading "Next Date"     format a20
column BROKEN           heading "B|r|o|k|e|n"   format a3
column INTERVAL         heading "Interval"      format a24
column FAILURES         heading "F|a|i|l"       format 99
column WHAT             heading "What"          format a74

SELECT  job,
        to_char(last_date, 'DD-Mon-YYYY HH24:mi:ss') last_date,
        to_char(next_date, 'DD-Mon-YYYY HH24:mi:ss') next_date,
        decode(broken, 'Y', 'Yes', 'No') broken,
        interval,
        failures
FROM    dba_jobs
/

SELECT  job,
        what
FROM    dba_jobs
/

Get Oracle Distributed Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial