Platform Deployment Guide › Data Warehouse › Advanced Configuration › Change the Job Frequency › Change the Job Frequency on SQL Server CMSs

Change the Job Frequency on SQL Server CMSs

Note: If you change the job frequency, you must be logged onto the CMS database as the primary user. This is the account that CA DataMinder uses to access the CMS database.

SQL Server CMSs

Edit the following SQL Server job:

DLP_Aggregation_<CMS database>

Where <CMS database> is the name of CMS database.

SQL Server Express CMSs

Set up a scheduled data warehousing aggregation task using the Windows Task Scheduler:

1. Create a task to run the data warehousing batch file that you previously created.
2. Configure the task to run as the Windows user account that corresponds to the appropriate SQL Server login.
3. Specify a task schedule as required. We recommend that the data warehousing job runs hourly.