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"
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"
|
|
|