This script was useful when I worked at an organisation where we were upgrading from 11i to R12 We could use it to extract a list of scheduled requests, returning also when they ran, how often, at ...
MAX(t.period_end_time) AS run_end_time, MAX_BY(t.result_state, t.period_end_time) AS job_result_state, MAX_BY(t.termination_code, t.period_end_time) AS job ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results