gen_break_jobs.sql
Download Script
set heading off
set echo off
set verify off
set feedback off
set termout off
set pagesize 0
set termout on
prompt Creating dbms_job.broken commands
set termout off
spool break_jobs.sql
prompt spool break_jobs.log
break on priv_user
select priv_user, ' exec dbms_job.broken(' || job || ',true)' from dba_jobs
order by priv_user
/
prompt spool off
spool off