Minutely task failing after deleting pending jobs from the Operator Console (NETIQKB72682)

  • 7772682
  • 12-Nov-2010
  • 12-Nov-2010

Environment

AppManager 7.0.x

Situation

NetIQ Minutely QDB job is failing and producing an error that says it cannot delete or clean up a certain jobid because it has an 'incorrect status'.
NetIQ Minutely job fails to run successfully and so the minutely tasks are not completed as they should be.

Resolution

The minutely job is failing because it is attempting to delete jobids that have the incorrect status set so it fails to complete it's tasks. To remember this you will have to manually delete these jobs from the QDB using the following query:

To find the problematic jobs;

  • select * from job where jobid = ##### (where ##### is the jobid that you are looking for).

Most likely they will have a pending stop or pending start status and should have a status of 134217728. To resolve this run the following query for each problem jobid:

  • update job set status = 134217728 where jobid = #####

After completing this process for each jobid that was shown in the error the minutely job should then run correctly and remove those jobids from the database.

Cause

Jobs were manually removed from the Operator Console by deleting them while they were in a pending status, waiting on confirmation of a stopped status.

 

Additional Information

Formerly known as NETIQKB72682