Help - Search - Members - Calendar
Full Version: metadata for scheduler jobs
Oracle DBA Forums > Oracle > Oracle Forum
Asma
Can we get metadata details of a scheduled job using dbms_metadata or if there is anyway we can get ddl for it? kindly help

thnx.
burleson
>> Can we get metadata details of a scheduled job

Well, here is a simple query:

CODE
select
   job_id,
   freq_type,
   freq_interval,
   freq_subday_type,
   freq_subday_interval,
   freq_relative_interval,
   freq_recurrence_factor,
   active_start_date,
   active_end_date,
   active_start_time,  
   active_end_time,  
   schedule_id
from
   dba_scheduler_jobs;


For the whole enchilada, Dr. Hall has a whole bunch of scripts for this in his book "Oracle Job Scheduling":

http://www.rampant-books.com/book_2005_1_scheduling.htm
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.