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

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 11:46:46 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.