>> 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