DBA Data[Home] [Help]

VIEW: SYS.DEFSCHEDULE

Source

View Text - Preformatted

SELECT dblink, job, interval, next_date,
         last_date, disabled, last_txn_count, last_error_number,
         last_error_message, catchup,
         total_txn_count,
         avg_throughput,
         avg_latency,
         total_bytes_sent,
         total_bytes_received,
         total_round_trips,
         total_admin_count,
         total_error_count,
         total_sleep_time,
         disabled_internally_set
    FROM sys."_DEFSCHEDULE"
View Text - HTML Formatted

SELECT DBLINK
, JOB
, INTERVAL
, NEXT_DATE
, LAST_DATE
, DISABLED
, LAST_TXN_COUNT
, LAST_ERROR_NUMBER
, LAST_ERROR_MESSAGE
, CATCHUP
, TOTAL_TXN_COUNT
, AVG_THROUGHPUT
, AVG_LATENCY
, TOTAL_BYTES_SENT
, TOTAL_BYTES_RECEIVED
, TOTAL_ROUND_TRIPS
, TOTAL_ADMIN_COUNT
, TOTAL_ERROR_COUNT
, TOTAL_SLEEP_TIME
, DISABLED_INTERNALLY_SET
FROM SYS."_DEFSCHEDULE"