Home » SQL & PL/SQL » SQL & PL/SQL » How to find ALL jobs that have run till date ? (Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production)
How to find ALL jobs that have run till date ? [message #338578] Tue, 05 August 2008 06:56 Go to next message
NewLife
Messages: 170
Registered: April 2008
Senior Member
Hi guys,

Is there any way i can find out ALL the jobs that have run or that have atleast been submitted to dbms_jobs till today or sysdate ?


[Updated on: Tue, 05 August 2008 07:01]

Report message to a moderator

Re: How to find ALL jobs that have run till date ? [message #338592 is a reply to message #338578] Tue, 05 August 2008 07:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query DBA_JOBS.

Regards
Michel
Re: How to find ALL jobs that have run till date ? [message #338595 is a reply to message #338592] Tue, 05 August 2008 07:24 Go to previous messageGo to next message
NewLife
Messages: 170
Registered: April 2008
Senior Member
Hmm that would give me only the current jobs in the queue, i want all the jobs that have been submitted till date
Re: How to find ALL jobs that have run till date ? [message #338602 is a reply to message #338595] Tue, 05 August 2008 07:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way.

Regards
Michel
Re: How to find ALL jobs that have run till date ? [message #338604 is a reply to message #338602] Tue, 05 August 2008 07:32 Go to previous messageGo to next message
NewLife
Messages: 170
Registered: April 2008
Senior Member
Wish Oracle could do something about that Smile

thanks anyways Michel Smile
Re: How to find ALL jobs that have run till date ? [message #338606 is a reply to message #338595] Tue, 05 August 2008 07:35 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
There's no way of retrieving this data for historical jobs that I know about.
Previous Topic: unable to view procedure
Next Topic: Where Clause in sql
Goto Forum:
  


Current Time: Sun Dec 04 08:50:35 CST 2016

Total time taken to generate the page: 0.07332 seconds