Home » SQL & PL/SQL » SQL & PL/SQL » dbms_jobs (
dbms_jobs [message #347871] Sun, 14 September 2008 14:03 Go to next message
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 Go to previous messageGo to next message
Messages: 49
Registered: April 2008
Location: Brighton, Michigan
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).
Re: dbms_jobs [message #347911 is a reply to message #347881] Mon, 15 September 2008 01:07 Go to previous message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I presume that you are using 9i

You assume wrong as in the title you can see Wink
And using 10g does not imply using Oracle scheduler. I use 10g and most often use old jobs rather than scheduler: easier to use and transactional.

You solution is good and actually the only one.

Previous Topic: select from Index-By Table in a package has errors
Next Topic: Mutating Triggers
Goto Forum:

Current Time: Fri Aug 18 18:36:15 CDT 2017

Total time taken to generate the page: 0.40713 seconds