OraFAQ Forum: SQL & PL/SQL » List of jobs created thru DBMS

Home » SQL & PL/SQL » SQL & PL/SQL » List of jobs created thru DBMS_SCHEDULER (Oracle Database 10g Release 10.2.0.3.0, Windows Server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

List of jobs created thru DBMS_SCHEDULER [message #334550]

Thu, 17 July 2008 01:32

smora
Messages: 59
Registered: May 2006

Member

Hi

How do i see all the jobs that have been created thru DBMS_SCHEDULER.CREATE_JOB?

The table dba_jobs and user_jobs contain only the materialized views and their refresh interval information etc. and not the jobs I have create thru DBMS_SCHEDULER.CREATE_JOB.

Thanks
SM

Report message to a moderator

Re: List of jobs created thru DBMS_SCHEDULER [message #334555 is a reply to message #334550]

Thu, 17 July 2008 01:42

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

Senior Member
Account Moderator

select * from dict where table_name like '%SCHEDULER%';

Regards
Michel

Report message to a moderator

Re: List of jobs created thru DBMS_SCHEDULER [message #334560 is a reply to message #334550]

Thu, 17 July 2008 02:24

smora
Messages: 59
Registered: May 2006

Member

Thanks Michel, USER_SCHEDULER_JOBS had the information I was looking for.

Regards
SM

Report message to a moderator

Previous Topic:	Ref curosr or Collections
Next Topic:	Is it a good idea to use REF_CURSOR to select subset of data?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 02 20:26:50 CST 2025