Answers for "dba_jobs history"

SQL
2

dba_jobs history

SELECT LOG_DATE, OWNER, JOB_NAME, JOB_SUBNAME, STATUS,
       ACTUAL_START_DATE, RUN_DURATION, CPU_USED, ADDITIONAL_INFO
FROM ALL_SCHEDULER_JOB_RUN_DETAILS   	-- or DBA_SCHEDULER_JOB_RUN_DETAILS
WHERE JOB_NAME = 'job_name'
ORDER BY LOG_DATE DESC;
Posted by: Guest on July-26-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language