Diagnosing Problems with Jobs

Many operations in a replication environment rely on jobs to perform work. While monitoring your system, you might find that there are problems related to jobs. You must monitor local jobs regularly.

If a job fails to execute, first check to see the status of the job. If the job is broken, check the alert log and trace files for error information and fix the error. If the job is not broken (normal), then Oracle should ultimately re-execute it.

If the job is normal but has never executed, there may be a problem with the availability of job queue processes (Job Queue Processes). Check the initialization parameter JOB_QUEUE_PROCESSES to determine the number of job queue processes available. You can also query the DBA_JOBS_RUNNING data dictionary view to explore what jobs these processes are currently running, and the alert log and trace file can provide you with additional information about potential problems with the job queue process.