OraFAQ Forum: SQL & PL/SQL » How to find ALL jobs that have run till date ?

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)

Tue, 05 August 2008 06:56

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]

Tue, 05 August 2008 07:21

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Query DBA_JOBS.

Regards
Michel

Tue, 05 August 2008 07:24

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

Tue, 05 August 2008 07:30

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No way.

Regards
Michel

Tue, 05 August 2008 07:32

NewLife
Messages: 170
Registered: April 2008

Senior Member

Wish Oracle could do something about that Smile

thanks anyways Michel Smile

Tue, 05 August 2008 07:35

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: Thu Jan 22 20:55:19 CST 2026