I got a requirement to take the elapsed time duration of the each and every job in oracle 10 g database.
->>>I need a last execution elapsed time of the jobs.Can any one help me on this?
Job A started to execute at 10:00 AM and it takes 10 mins to executed the job and completed at 10:10 AM.
i need a output for the above scenario as follows,which is the elapsed time 10:00 mins/seconds.
Can any one help me in this..
Query dba_scheduler_job_run_details (or all|user_scheduler_job_run_details) ...it contains a column called RUN_DURATION
Message was edited by: Hoek (added link)