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

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

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.

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.

Formerly known as NETIQKB70575