This discussion is archived
1 Reply Latest reply: Sep 10, 2013 7:18 AM by Hoek RSS

job execution elapsed time

Pandiyan_Senthur Newbie
Currently Being Moderated



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?


For example:

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..





  • Correct Answers - 10 points
  • Helpful Answers - 5 points