KB 540110: How to configure filter jobs to not run on all Partitions after install
After deploying the Audit Collection Base Reporting, the solution will start to run daily jobs to load various filter tables. By default this job runs every night at 2:30am and on first use will scan all unarchived partitions for processing. Due to some customers environments, database size, resource limitations or current ACS health it is not always desirable to perform this filter load on all existing partitions.
Customers can run a single update to the Audit Collection Database (Default: OperationsManagerAC) filterload table which inserts and flags existing partitions as processed. The next time the FilterLoad job runs it will only process inactive partitions that are not in the history table.
Configuration Steps
Below is a SQL command to manually update the partition FilterLoad table so the next job will only process the most recent inactive partition.
Note:This command should only be used on a fresh installation of the Audit Collection Base Reporting when applicable.
INSERT INTO [dbo].[SVT_PartitionFilterLoad] ([PartitionId] ,[LastLoadID] ,[PartitionStatusFlag]) SELECT [PartitionId] , 0 , 'C' FROM [dbo].[dtPartition]WHERE Status <> 0
As the filter job runs daily the lookup tables will be updated over time.
For further assistance or questions on the Filter Job please contact support at support@securevantage.com
|