Business Intelligence Tutorial

Scheduling warehouse processes

In this lesson, you will specify that the steps in the Tutorial Market process are to run in the following sequence:

  1. Load Demographics Data
  2. Select Geographies Data
  3. Join Market Data

Then you will specify that the Load Demographics Data step is to run at a scheduled time. You will activate the schedule by promoting the steps in the process to production mode.


Running steps in sequence

To specify that the steps are to run in sequence:

  1. From the Data Warehouse window, right-click on the Build Tutorial Market Dimension process and click Open.
  2. From the Process Model window, click the Task Flow icon:
    Figure arrowcol not displayed.
  3. Click the On Success icon (the green arrow).

    On Success indicates that a step is to be started only if the step before it ran successfully. You can also select the following states:

    On Completion
    Indicates that a step is to be started when the step before it runs successfully or fails. (The blue arrow.)

    On Failure
    Indicates that a step is to be started only if the step before it failed. (The red arrow.)

    For more information, see "Scheduling a step" in the online help.

  4. Click the Load Demographics Data step, which is the step that is to run first.
  5. Hold down the mouse button and drag the mouse to the Select Geographies Data step, which is to run after the Load Demographics step.
  6. Release the mouse button.

    A green arrow that represents the task flow is displayed on the canvas between the two steps.

  7. Repeat steps 4 to 6 with the Select Geographies Data step and the Join Market Data step. This specifies that the Select Geographies Data step will run before the Join Market Data step.
    The GEOGRAPHIES SELECT statement on the SQL Statement page.

    The steps will now run in the order that is listed in the introduction to this lesson.


Scheduling the first step

Now, you will schedule the Load Demographics Data step, to start at a specified date and time. The Data Warehouse Center will start the step at the time you specify. When the Load Demographics Data step finishes running, the Data Warehouse Center starts the next step in the sequence that you defined in the previous section.

When you schedule a step, you can specify one or more dates and time on which the step is to run. You can also specify the step is to run once or is to run at a specified interval, such as every Saturday.

To schedule the Load Demographics Data step:

  1. Right-click the Load Demographics Data step, and click Schedule.

    The Schedule notebook opens.

  2. From the Interval list, click Yearly.
  3. In the Start date and time field, accept the default of the current date, and specify a time that is a few minutes from the current time.

    The step will run at the time you select.

  4. In the End field, accept the default that the schedule is to run indefinitely.
  5. Click Add.

    The schedule is added to the Schedule list.
    The GEOGRAPHIES SELECT statement on the SQL Statement page.

  6. Click OK.

    The specified schedule is created.


Promoting the steps to production mode

To activate the schedule and the task flow links that you created, you must promote the steps to production mode. Production mode indicates that the steps are in their final format. In production mode, you can change only those settings that will not affect the step's processing, such as changing the description of the step. For more information, see the Data Warehouse Center Administration Guide.

To promote the steps to production mode:

  1. Right-click the Load Demographics data step.
  2. Click Mode --> Production, then click Yes to save.

    The Data Warehouse Center displays a progress window. Wait until the Data Warehouse Center finishes processing before continuing with this lesson. When the progress window closes, the step icon changes to show two locks indicating that the step is in production mode.

  3. Repeat the previous steps for the Select Geographies Data step and Join Market Data steps, in order.
  4. Close the Process Model Window.

What you just did

In this lesson, you scheduled the steps that you created to run once a year at the current date and time in the following order:

  1. Load Demographics Data
  2. Select Geographies Data
  3. Join Market Data

Then you promoted the steps to production mode to implement the schedule.


[ Top of Page | Previous Page | Next Page | Table of Contents ]