Scheduling a Dataflow

A dataflow schedule runs a job or process flow automatically at a specific time. You can schedule a dataflow to run once, or set up recurring execution.

  1. If you have not already done so, expose the job or process flow.

    You can expose jobs and process flows by opening the job or process flow in Enterprise Designer and selecting File > Expose/Unexpose and Save.

  2. Open the Management Console.
  3. Browse to Execution then click Scheduling.
  4. Click Add to create a new schedule or, if you want to modify an existing schedule, choose the schedule and click Modify.
  5. In the Add Task or Modify Task window, choose the settings for this task.
    • Task Name—The name you want to give to this scheduled task. This is the name that will be displayed in the task listing.
    • Flow type—Choose the type of process you are scheduling, either a job or a process flow.
    • Flow name—Select the job or process flow that you want to schedule. Only jobs and process flows that are saved and exposed are available here. If the job or process flow that you want is not shown, open the job or process flow in Enterprise Designer then select File > Expose/Unexpose and Save.
    • Enable task—Check this box to run the job or process flow at the specified time. Clear this box to suspend the schedule.
    • Schedule—Specify the date and time you want the job or process flow to run.
  6. If the flow uses files for input or output, those files must reside on the Spectrum™ Technology Platform server or on a file server defined as an external resource in Management Console. This applies both to jobs as well as job activities within a process flow. If a source or sink stage references a file on a client computer do one of the following:
    Option Description
    Option 1: Modify the dataflow Move the file to the Spectrum™ Technology Platform server or file server then modify the dataflow:
    1. Open the flow in Enterprise Designer.
    2. Double-click the source or sink stage.
    3. In the File name field, click the browse button.
    4. Click Remote Machine then select the file you want.
      Note: If you are running Enterprise Designer on the same machine as the Spectrum™ Technology Platform server, it will appear that clicking Remote Machine is no different than clicking My Computer. However, you must select the file using Remote Machine in order for the system to recognize the file as being on the Spectrum™ Technology Platform server.
    Option 2: Override the dataflow file location when this schedule runs You can override the input file specified in the dataflow's source stage (such as Read from File), as well as the output file specified in the dataflow's sink stage (such as Write to File).
    1. Click Options.
    2. Under Stage file locations select the stage that references a local file.
    3. Click Modify and select the file on the Spectrum™ Technology Platform server.
  7. If you want the job or process flow to run on a recurring schedule, check the Task recurrence check box then click the Recurrence button and complete the fields.
  8. If the dataflow has been configured for email notification, you can specify additional recipients for the notifications that will be sent when the dataflow runs.
    1. Click Options.
    2. Under Notification, click Add.
    3. Enter the email address you want the notification to be sent to. For example, me@mycompany.com.
    4. Click OK.
    Note: Notification must be configured in Management Console in order for email notifications to work. In addition, verify that the dataflow has been configured to support notification. To do this, open the dataflow in Enterprise Designer, select Edit > Notifications.
  9. Click OK.