 |
|
Oracle Replication Tips by Burleson |
Oracle Broken Job Fix
than zero but not broken, we can focus our monitoring on the broken
jobs. The BROKEN column is a Boolean value set to “N” or “Y”.
Select job
from user_jobs
where
SEE CODE DEPOT
Since we know how to find the broken jobs and fix them, it is a
simple matter to automate the process. The SQL script below will
find all the broken jobs for a user, create another script to fix
the broken jobs (run_unbroken.sql), and then run the repair script.
unbroken.sql
--**********************************************
--
-- Copyright © 2003 by Rampant TechPress Inc.
--
-- Free for non-commercial use.
-- For commercial licensing, e-mail info@rampant.cc
--
-- *********************************************
set heading off;
set pages 0;
set feedback off;
spool /tmp/run_unbroken.sql
select
'exec dbms_job.broken('||
job||
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.
|
