Verifying the Extract, Transform, and Load scheduling

After you upgrade, you should ensure that the Extract, Transform, and Load (ETL) process is retrieving data from the OnCommand Insight databases, transforming the data, and saving it into the data marts.

Steps

  1. Log in to the Data Warehouse portal at https://fqdn/dwh.
  2. From the navigation pane on the left, click Schedule.
  3. Click Edit schedule.
  4. Verify that Daily is selected from the Type list.
    The best practice is to schedule ETL to run once a day.
  5. Verify that the time selected is the time at which you want the job to run.
    This ensures that the build job runs automatically.
  6. Click Save.