rem
rem this script gives the jobs scheduled in Oracle
rem
rem Biju Thomas
rem
ttitle 'Jobs Scheduled Through Oracle'
column job format 999
column what format a20
spool /tmp/jobd.lst
set pages 999 lines 80 pau off time on verify off feedback off trims on
select job, what, last_date, last_sec, next_date, next_sec, failures, broken 
from   dba_jobs 
order by job
/
spool off
ttitle off
clear columns
set pages 24 verify on feedback on
prompt 
prompt Output saved at /tmp/jobd.lst
prompt