Deployment Guide › iConsole Standard Searches, Reports and Policies › Dashboard Data Aggregation › Manually Schedule Aggregation Jobs for SQL Server Express

Manually Schedule Aggregation Jobs for SQL Server Express

If your base machine uses a SQL Server Express database, you must schedule the aggregation jobs using the Windows Scheduled Tasks wizard.

To schedule aggregation jbs for SQL Server Express

1. Create a SQLCMD aggregation script.

   To do this, Save the following SQL Server query to a batch file, such as Dashboard_Agg.cmd:

   sqlcmd -E 
   -D WGN_<machine name> 
   -Q "EXEC rut_dlp_aggregation_process"
   

   where:

   -E

   Specifies a trusted database connection. You must ensure the scheduled task runs as a Windows user (see step 2-4 below) who has a SQL Server login that has been granted the db_owner privilege on the WGN_<machine name> database.

   -D WGN_<machine name>

   Defines the database name. This database name incorporates the name of the CMS host server.

   -Q

   Specifies a database query, in this case:

   "EXEC rut_dlp_aggregation_process"
   

2. Set up a scheduled aggregation task using the Windows Scheduled Tasks wizard.
   1. Open Scheduled Tasks in the Systems Tools folder.
   2. When the wizard prompts you for the program you want to run, choose the batch file you created in step 1.
   3. Specify a scanning schedule as required.

      Note: If you want to run aggregations more often than once every day, you will need to edit advanced properties for the scheduled task; do this in the final wizard screen.

   4. When the wizard prompts you for a user account, choose a Windows user that corresponds to the appropriate SQL Server login.