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)
List of jobs created thru DBMS_SCHEDULER [message #334550] Thu, 17 July 2008 01:32 Go to next message
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

Re: List of jobs created thru DBMS_SCHEDULER [message #334555 is a reply to message #334550] Thu, 17 July 2008 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
select * from dict where table_name like '%SCHEDULER%';

Regards
Michel
Re: List of jobs created thru DBMS_SCHEDULER [message #334560 is a reply to message #334550] Thu, 17 July 2008 02:24 Go to previous message
smora
Messages: 59
Registered: May 2006
Member
Thanks Michel, USER_SCHEDULER_JOBS had the information I was looking for.

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


Current Time: Tue Feb 11 16:53:37 CST 2025