Oracle: Duration of a scheduler Job

2.3k Views Asked by At

I want to know the duration of a scheduler Job, but what I get from the DB is null !

select LAST_RUN_DURATION from USER_SCHEDULER_JOBS
1

There are 1 best solutions below

0
On BEST ANSWER

Join the 2 views:

SELECT l.LOG_ID,l.LOG_DATE,l.JOB_NAME,l.STATUS,dets.RUN_DURATION
FROM ALL_SCHEDULER_JOB_LOG l
JOIN all_scheduler_job_run_details dets  ON l.LOG_ID = dets.LOG_ID