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

Hi,

 

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

 

Thanks,

Senthur

Legend

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