QUERY TO FIND OUT JOBS SCHEDULED IN DBA_SCHEDULER_JOBS

set verify off


select
   owner,
   job_name,
   job_class,
   enabled,
   to_char(next_run_date, 'hh24:mi:ss dd-mm-yyyy'),
   repeat_interval
from
   dba_scheduler_jobs
where
   owner = decode(upper('&1'), 'ALL', owner, upper('&1'))
;