dbms_jobs [message #347871] |
Sun, 14 September 2008 14:03  |
ihzaidi
Messages: 1 Registered: September 2008
|
Junior Member |
|
|
I am new to dbms_job.
I have job that runs every day using dbms_jobs. I see a total_time for the number for times job executed.
I need to know if there is a way to find out how long the last job ran.
I apprecite your feedback.
[Updated on: Sun, 14 September 2008 14:05] Report message to a moderator
|
|
|
Re: dbms_jobs [message #347881 is a reply to message #347871] |
Sun, 14 September 2008 21:21   |
TheSingerman
Messages: 49 Registered: April 2008 Location: Brighton, Michigan
|
Member |
|
|
Since you are using DBMS_JOB and not the scheduler, I presume that you are using 9i and don't have available the reports and notifications which 10g and its version of OEM can give you. So, the simple solution (since tomorrow you will be asking for the time of last week's job) is to create a little history table for all your site's statistics, write a little stored procedure to store the relevant statistics, and make it a convention to call it at the end of each job. (You will want to think through your commit conventions).
|
|
|
|