1 Reply Latest reply: Sep 10, 2013 9:18 AM by Hoek RSS

    job execution elapsed time

    Pandiyan_Senthur

      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