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.

Steps

  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: for example, daily or weekly.
  5. Choose the time at which you want the job to run.
    This ensures that the build job runs automatically.
  6. To enable the schedule, select Enabled.
    Note: If you do not check this, the schedule build does not occur.
  7. Click Save.
  8. To build Data Warehouse outside of the automatic scheduled build, click Build now.