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: 68665
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

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: Mon Jul 01 00:25:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.