Business Intelligence Tutorial

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.


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