defschedule.sql

---------------------------------------------------------------------------
-- Filename:   defschedule.sql
-- Purpose:    Returns information about scheduled transactions.
-- Author:     Chas.Dye (cdye@excitecorp.com)
-- Date:       31-Jul-1996
---------------------------------------------------------------------------
column dblink           heading "DB Link"               format a20
column JOB              heading "Job"                   format 999
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 a22
column FAILURES         heading "F|a|i|l"               format 999
column WHAT             heading "What"                  format a75
column last_txn_count   heading "Last|Txn|Count"        format 999

SELECT  dblink,
        job,
        to_char(next_date, 'DD-Mon-YYYY HH24:mi:ss') next_date,
        to_char(last_date, 'DD-Mon-YYYY HH24:mi:ss') last_date,
        disabled,
        last_txn_count
FROM    defschedule
/

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