Skip to main content
OnCommand Insight

Scheduling daily builds


Although you can manually build Data Warehouse by using the Build now control at any time, it is best practice to schedule automatic builds, defining when and how often to build the Data Warehouse database. Data Warehouse performs a build job for each connector and for each data mart. Data Warehouse performs a build job for each connector for licenses and inventory and all other build jobs (for example, capacity) are performed on the consolidated database.

About this task

Whenever the Data Warehouse is built, it performs an inventory job for every connector. After the inventory jobs are complete, Data Warehouse performs jobs for dimensions, capacity, and the remaining data marts.


  1. Log in to the Data Warehouse Portal at https://hostname/dwh, where hostname is the name of the system where OnCommand Insight Data Warehouse is installed.

  2. From the navigation pane on the left, click Edit Schedule.

    DWH Schedule Link
  3. In the Build Schedule dialog box, click Edit to add a new schedule.

    DWH Schedule Edit
  4. Choose the frequency - weekly.

  5. Choose the time of day for each day you want the job to run.

  6. Chose N/A for days you do not want to run the build.

  7. To enable the schedule, select Enabled.


    If you do not check this, the schedule build does not occur.

  8. Click Save.

  9. To build Data Warehouse outside of the automatic scheduled build, click Build now.