Oracle Replication Tips by Burleson

Monitoring Oracle Jobs

instead. Otherwise, monitoring will have to run within the job scheduler of each schema.   The primary data fields in dba_jobs are:

• BROKEN – A Boolean value that indicates if the job is active or broken (inactive).
   

• FAILURES – Indicates the number of failures that have been recorded for the job.
   

• INTERVAL – This is the interval that will occur between job executions.
   

• NEXT_DATE – This is the next time the job will be executed.
   

• SCHEMA_USER – Indicates the user that the scheduler will use to execute the job.
   

• WHAT – This column describes the job. This is the actual procedure that will get executed.

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.