select job, last_date, last_sec, next_date, next_sec, broken, interval, failures, what from user_jobs order by job asc;

select 'declare jobno number; begin dbms_job.submit(jobno, ''' || replace(replace(what, 'BEGIN', ''), 'END;', '') || ''', sysdate, ''' || replace(interval, '''', '''''') || ''', FALSE); end;' from user_jobs where broken = 'N';