Oracle Replication Tips by Burleson

Oracle Broken Job Fix

   ',FALSE,sysdate + 1/288);'
from
   user_jobs
SEE CODE DEPOT FOR FULL SCRIPT
; 

select
   'execute dbms_job.run(' ||
   job||
    ');'
from
   user_jobs
SEE CODE DEPOT FOR FULL SCRIPT
; 

spool off
set feedback on

@@/tmp/run_unbroken.sql
exit;

Here is an example of what the content in the generated script might look like:

exec dbms_job.broken(3,FALSE,sysdate + 1/288);
exec dbms_job.broken(9,FALSE,sysdate + 1/288);
exec dbms_job.broken(22,FALSE,sysdate + 1/288);
exec dbms_job.broken(23,FALSE,sysdate + 1/288);
exec dbms_job.broken(109,FALSE,sysdate + 1/288);
execute dbms_job.run(3);
execute dbms_job.run(9);
execute dbms_job.run(22);
execute dbms_job.run(23);
execute dbms_job.run(109);

This is an excerpt from Oracle Replication By Rampant TechPress (only $19.95).  You can click here to order a copy and get instant access to the code depot:

http://www.rampant-books.com/book_2003_2_replication.htm

Get a Personal Oracle Replication Mentor

The author is now offering personal mentors for Oracle DBAs where you can have an Oracle expert right at your fingertips, anytime day or night. We work with hundreds of Oracle databases every year, so we know exactly how to quickly assist you with any Oracle replication question. 

You can get me personally, or any Oracle Certified replication DBA with more than 20 years of full-time IT experience.