Home » RDBMS Server » Server Administration » How to view old information about dbms_jobs? (10.2.0.4 win 2003 x64)
How to view old information about dbms_jobs? [message #431450] Tue, 17 November 2009 06:37 Go to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

As we still have some databases that still uses dbms_job, is there a view or table with old information about how long the job took the last time and stuff like that?

Regards
Hristo
Re: How to view old information about dbms_jobs? [message #431454 is a reply to message #431450] Tue, 17 November 2009 06:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No you only have the total time for all executions (for a regular job and nothing for a one shot one).

Regards
Michel

Re: How to view old information about dbms_jobs? [message #431460 is a reply to message #431450] Tue, 17 November 2009 06:58 Go to previous message
hristo
Messages: 258
Registered: May 2007
Senior Member
Ok, thanks for a quick reply.

Regards
Hristo
Previous Topic: migration steps from oracle9i to 11g on solaris
Next Topic: oracle Table and its dependent Object defination
Goto Forum:
  


Current Time: Sat Dec 10 16:57:57 CST 2016

Total time taken to generate the page: 0.26060 seconds