Deployment Guide › iConsole Standard Searches, Reports and Policies › Dashboard Data Aggregation › Change the Aggregation Frequency

Change the Aggregation Frequency

By default, aggregations run every hour. But if required, you can change the aggregation frequency.

To change the aggregation frequency

Run the following commands to change the aggregation frequency. In each case, you must be logged onto the CMS database as the primary user. This is the account that CA DLP uses to access the CMS database.

SQL Server CMSs

You must edit SQL Server job:

DLP_Aggregation_<CMS database>

Where <CMS database> is the name of CMS database. Note that if you do change the aggregation frequency, do not set a frequency shorter than the timeslot length as this will waste DBMS resources.

Note: If using a SQL Server Express database, you set the aggregation frequency when you set up a scheduled task using the Windows Scheduled Tasks wizard.

Oracle CMSs

You can specify a repeat interval for a specified aggregation job. First, you need to check the job name and confirm its next run time. To do this, run the following SQL query:

SELECT OWNER, JOB_NAME, SUBSTR(REPEAT_INTERVAL,1,40) 
AS REPEAT_INTERVAL, 
NEXT_RUN_DATE 
FROM ALL_SCHEDULER_JOBS;

Now you can set the aggregation frequency. To do this, run the following PL/SQL command. This example sets the aggregation job to run at 2:00 AM every night:

BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE
(name => 'DLP_AGGREGATION_<DBNAME>',
attribute => 'repeat_interval', 
value => 'FREQ=DAILY; BYHOUR=2' );
END;

Where DLP_AGGREGATION_<DBNAME> is the JOB_NAME returned from the SQL query above

More information:

Timeslot Length

Manually Schedule Aggregation Jobs for SQL Server Express