April 1999
Intermediate to advanced
552 pages
15h 39m
English
---------------------------------------------------------------------------
-- 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
/