dba_autotask_job_history shows history of autotask jobs. dba_scheduler_job_run_details whose names start with ORA$AT and joins them to dba_autotask_window_history select joh.client_name, joh.window_name, joh.window_start_time, joh.window_duration, joh.job_name, joh.job_status, joh.job_start_time, joh.job_duration, joh.job_error, joh.job_info from dba_autotask_job_history joh order by joh.job_start_time desc;