Schedule a Data Flow

You can schedule a data flow to run at a particular time or on a recurring basis such as hourly, daily, monthly, or yearly.

For example, you can create a scheduled task to ensure that the new data is available on specific days of the week or to run a data flow after the data sources are updated.

Create a Scheduled Task for a Data Flow

You can create a new scheduled task and specify its properties such as date, time, and frequency.

  1. Go to the Data page and select Data Flows.
  2. Select a data flow and click the Actions menu or right-click, then click New schedule.
  3. In the Schedule dialog, specify the name, start date, start time, and repeat.
    • In the Repeat field, select the frequency of the scheduled task such as Hourly, Daily, Weekly, Monthly, and Yearly. For each frequency type, you have to define particular properties such as the end date, specific days of the week, or dates in the month.
  4. If you’ve added parameters to the data flow, in the Parameters section, specify other values.
    • In the Source field, click the source data set. In the Add Data Set dialog, select a new data set and click Add.
    • In the Targets field, change the data set name. For a data flow with Create Essbase Cube step, change the Application and Cube names.
  5. Click OK.

Modify a Scheduled Task

You can check and modify the predefined properties of the scheduled task.

  1. Go to the Data page and select Data Flows.
  2. Select a data flow for which you’ve added a scheduled task.
  3. Click the Actions menu or right-click and click Inspect.
  4. In the data flow inspector dialog, click the Schedules tab, then select a scheduled task.
  5. Check and modify the properties such as name, start date, start time, and frequency.
  6. Click Save, then click Close.