SQL Job NetIQ Weekly Tasks runs for a long time causing issues for other SQL jobs (NETIQKB70575)

  • 7770575
  • 08-Aug-2007
  • 15-Feb-2012

Environment

NetIQ AppManager 6.0.x
NetIQ AppManager 7.0.x
NetIQ AppManager 8.x

Situation

SQL Job NetIQ Weekly Tasks runs for a long time causing issues for other SQL jobs
NetIQ Weekly QDB task in SQL runs for a very long time

Resolution

This is normal behavior.

If the task is taking too long (and possibly preventing other SQL tasks from completing) you can set your Aggregation timeframe (retention period) to a longer amount of retention time, which will reduce the amount of data needing to be Aggregated.  You should then manually re-run the NetIQ Weekly QDB job.  This should allow the task to run in a shorter amount of time.

You can then increment the Aggregation retention value in small amounts, slightly reducing the amount of data to retain each time, and then again re-run the NetIQ Weekly QDB job manually each time that you further shorten the Aggregation period.

Once you've Aggregated Archive Data down to the intended level of retention, the NetIQ Weekly QDB SQL job should take less time to complete on its own during its regularly scheduled weekly iterations.

Cause

Aggregation is turned on, and depending on the volume of data needing to be aggregated, this process can take a very long time to complete.

Additional Information

Formerly known as NETIQKB70575

Feedback service temporarily unavailable. For content questions or problems, please contact Support.