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;