Platform Deployment Guide › Data Warehouse › Enable the Data Warehouse at Install Time › Enable the Data Warehouse on SQL Server Express CMSs

Enable the Data Warehouse on SQL Server Express CMSs

If your data warehouse is hosted in a SQL Server Express database, you must manually enable and schedule the processing jobs that populate the data warehouse.

To enable the data warehouse on SQL Server Express CMSs

1. Create a SQLCMD script to run data warehousing jobs.

   Specifically, save the following SQL Server query to a batch file, such as Data_Warehouse_Job.cmd:

   sqlcmd -E -d "WGN_<server>" -Q "EXEC rut_dlp_aggregation_process"
   

   Where:

   -E

   Specifies a Windows-trusted database connection. You must ensure the scheduled task runs as a Windows user who has a SQL Server login that has been granted the db_owner privilege on the WGN_<machine name> database. This is the default.

   -D "WGN_<server>"

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

   -Q

   Specifies the database query:

   "EXEC rut_dlp_aggregation_process"
   

2. Set the job frequency by using the Windows Scheduled Tasks wizard.

   See the reference below for details.

To enable the data warehouse for a non-default instance of SQL server

1. Create a SQLCMD script to run data warehousing jobs.

   Specifically, save the following SQL Server query to a batch file, such as Data_Warehouse_Job.cmd:

   sqlcmd -S "localhost\SQLEXPRESS" -d "WGN_<server>" -Q "EXEC rut_dlp_aggregation_process"
   

   Where:

   -S "<host>"

   Specifies the host machine and the default instance of SQL Server.

   -S "<host>\<instance>"

   Specifies the host machine and a named (non-default) instance of SQL Server.

   -D "WGN_<server>"

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

   -Q

   Specifies the database query:

   "EXEC rut_dlp_aggregation_process"
   

2. Set the job frequency by using the Windows Scheduled Tasks wizard.

   See the reference below for details.

More information:

Change the Job Frequency