Using
add_table_propagation_rules
SELECT
'Propgation name : ' ||
p.propagation_name || chr(10) ||
'start_date : ' ||
TO_CHAR(s.start_date, 'HH24:MI:SS MM/DD/YY') ||
chr(10) ||
'propagation_window : ' ||
s.propagation_window || chr(10) ||
'latency : ' || s.latency ||
chr(10) ||
'schedule_disabled : ' ||
s.schedule_disabled || chr(10) ||
'next_run_date : ' ||
TO_CHAR(s.next_run_date, 'HH24:MI:SS MM/DD/YY')
|| chr(10) ||
'process_name : ' || process_name ||
chr(10) ||
'total_number : ' || total_number ||
chr(10) ||
'failures : ' || failures ||
chr(10) ||
'TOTAL_TIME : ' || TOTAL_TIME ||
chr(10) ||
'TOTAL_NUMBER(MSGS) : ' || TOTAL_NUMBER ||
chr(10) ||
'TOTAL_BYTES : ' || TOTAL_BYTES ||
chr(10) ||
'MAX_NUMBER(MSGS) : ' || MAX_NUMBER ||
chr(10) ||
'MAX_BYTES : ' || MAX_BYTES
propagate_schedule_profile
FROM dba_queue_schedules S ,
dba_propagation P
SEE CODE DEPOT FOR FULL SCRIPT
/
