history of all scheduler job runs - Oracle Database Script. SET pagesize 299 SET lines 299 col JOB_NAME FOR a24 col actual_start_date FOR a56 col RUN_DURATION FOR a34 SELECT job_name, status, actual_start_date, run_duration FROM DBA_SCHEDULER_JOB_RUN_DETAILS ORDER BY ACTUAL_START_DATE DESC;
SET pagesize 299 SET lines 299 col JOB_NAME FOR a24 col actual_start_date FOR a56 col RUN_DURATION FOR a34 SELECT job_name, status, actual_start_date, run_duration FROM DBA_SCHEDULER_JOB_RUN_DETAILS ORDER BY ACTUAL_START_DATE DESC;