Managing Oracle's job queue from PATROL


Warning

This feature is no longer supported by any of the KM's supported versions. From version 9.7.11.01, the feature is no longer available. For more information see, 9.7.11.01: Fix pack 1 for PATROL for Oracle Database.

You can use PATROL to view and manage the job queue in the Oracle instance. You can run jobs manually, flag jobs as broken or not broken, and remove jobs from the job queue.

Before you can manage the job queue, you must activate the JOBS application by choosing KM Admin > Monitor Settings Modify from the INSTANCE menu, and enabling the JOBS category. You can also use this function to deactivate job queue monitoring.

The CollJobs parameter starts collecting information and populates the consumer parameters during the next polling cycle. The JOBS icon should appear within two polling cycles.

Note

The administrative and reporting menu commands are not supported for jobs scheduled with the DBMS_SCHEDULER package.

Viewing all jobs in the queue

To view all the jobs in the job queue, choose Reports > All Jobs from the JOBS menu or Reports > Jobs > All Jobs from the INSTANCE menu. All the jobs currently in the job queue are listed in the report, with the following information for each job:



All jobs report

Item

Description

Job Owner

name of the owner of the job

Job Number

number of the job

Broken

whether the job is broken or not

Failures

how many times the job failed to run

Job Definition

PL/SQL code that defines the job

Next Run

time when the job is set to run next


Finding failed jobs

A failed job is an Oracle task that has not executed properly 15 or fewer times (if it fails to execute properly 16 times in a row, it is flagged as a broken job). The FailedJobs parameter graphs the number of jobs that have failed to run. You can also run the Failed Jobs Report by choosing*Jobs > Failed Jobs* from the JOBS menu or Reports > Jobs > Failed Jobs from the INSTANCE menu.

The following table lists the information included in the Failed Jobs report.



Failed jobs report

Item

Description

Job Owner

name of the owner of the job

Job Number

number of the job

Broken

whether the job is broken or not

Failures

how many times the job failed to run

Job Definition

PL/SQL code that defines the job

Next Run

time when the job is set to run next


If a job fails to run 16 times in a row, it is flagged as broken, it is removed from the Failed Jobs Report, and it appears in the Broken Jobs Report.

Note

If you are monitoring an Oracle 8.0.4 database on an IBM ® AIX ® host, the Failed Jobs report might not correctly report the number of times that a job has failed to run. A column in the dba_jobs table in Oracle does not increment the number of times that a job fails. The FailedJobs parameter reflects this Oracle problem.

Finding overdue jobs

An overdue job is a job that is more then two minutes overdue. An overdue job may be a broken job or a failed job, or it may simply be blocked from running at its appointed time. The OverdueJobs parameter graphs the number of jobs that have not run at their proper time.

You can see all overdue jobs by choosing Jobs > Overdue Jobs from the JOBS menu or Reports > Jobs > Overdue Jobs from the INSTANCE menu. All overdue jobs are listed in a text window. The following table lists the information in the report.



Overdue jobs report

Item

Description

Job Owner

name of the owner of the job

Job Number

number of the job

Broken

whether the job is broken or not

Failures

how many times the job failed to run

Job Definition

PL/SQL code that defines the job

Next Run

time when the job is set to run next


Finding broken jobs

If a job has failed to run 16 times, it is automatically flagged as broken and does not run again. You can view all broken jobs by choosing Jobs > Broken Jobs from the JOBS menu or Reports > Jobs > Broken Jobs from the INSTANCE menu. All broken jobs are listed in the text window. The following table lists the information in the report.



Broken jobs report

Field

Description

Job Owner

name of the owner of the job

Job Number

number of the job

Failures

how many times the job failed to run

Job Definition

PL/SQL code that defines the job


Flagging jobs

You can manually flag a job as broken if you do not want the job to run again until you have corrected a problem. After you have corrected the problem, you can flag the job as not broken, and it will run again during its next scheduled execution time.

  1. From the JOBS menu, choose Jobs > Flag Job > As Broken or Jobs > Flag Job > As Not Broken.
  2. Select the user name of the owner of the job from the list, type the owner's password, and click OK.
  3. Select one or more of the jobs that you want to flag, and click OK.
    If no unbroken or broken jobs exist, the task output window displays a message saying that no unbroken or broken jobs exist.

Running jobs immediately

Use the following task to manually execute a job immediately. When you run a job manually from PATROL, Oracle attempts to execute the job even if the job has failed or is broken.

  1. From the JOBS menu, choose Run Job.
  2. Select the user name of the owner of the job from the list, type the owner's password, and click OK.
  3. Select the job you want to run, and click OK.

Removing a job from the job queue

You can remove a job from the job queue, which prevents the job from being processed.

  1. From the JOBS menu, choose Remove Job.
  2. Select the user name of the owner of the job from the list, type the owner's password, and click OK.
  3. Select the job you want to remove, and click OK.
    You can remove all jobs that have not yet executed from the job queue. Jobs that you remove are not executed. However, you cannot remove a job that is currently executing. If you try to remove a job that is currently executing, the job is not interrupted and continues to execute.
Was this page helpful? Yes No Submitting... Thank you

Comments