Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_JOBS - Executed time report. (win XP, oracle 9i)
DBMS_JOBS - Executed time report. [message #321345] Tue, 20 May 2008 00:23 Go to next message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Hi all,

Need a help to get the date where a job executed.

A job has been scheduled every day 3pm, starting from jan 1 2008. Now we want the report of job executed time. In USER_JOBS we could see only the date for next day & previous day run.

How to get the executed date & time of a job from the scrap?

Note : i am using 9i version of oracle.

thiyagarajan palanisamy
Re: DBMS_JOBS - Executed time report. [message #321353 is a reply to message #321345] Tue, 20 May 2008 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no data on this in dictionary.
In DBA_JOBS you have TOTAL_TIME so you can record it each day in one of your table along with the execution date/time.

Regards
Michel
Re: DBMS_JOBS - Executed time report. [message #321376 is a reply to message #321353] Tue, 20 May 2008 01:59 Go to previous message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Thanks Michel ..

Now i am using seperate table for recording time ..

Thiyagarajan Palanisamy
Previous Topic: ORA-22160: element at index [2] does not exist
Next Topic: Error in Bulk insert
Goto Forum:
  


Current Time: Thu Dec 08 12:32:19 CST 2016

Total time taken to generate the page: 0.12480 seconds