Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

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