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