When configuring a schedule, you can chain a subsequent data flow to run based on whether the preceding data flow has succeeded or failed. Alternatively, if a scheduled data flow fails, you can configure the system to send an email to alert users of the failed run.
For example, you schedule a primary data flow to poll a website. When this data flow succeeds, it triggers a secondary data flow to run. Or, you schedule a primary data flow to copy files to a directory on a file system. If the run fails, you schedule a follow-up data flow to clean up any files that had been copied by the first data flow.
- Open the Schedule a Data Flow dialog.
If you have already created a schedule, you can open the Schedule a Data Flow dialog by selecting the schedule in the Directory, and clicking Edit.
If you have not yet created a schedule, see Creating a schedule.
- To select a second data flow to run if the primary data flow succeeds:
In the On Success, Run field, click the folder icon then browse to the data flow that you want to run when the primary data flow succeeds, then click Choose.
- If either the primary or secondary data flow fails, you can either trigger the run of another data flow, or you can send an email to notify users of the failed run:
To trigger the run of another data flow, in the On Failure section of the dialog, select Run Data Flow. Click the folder icon to navigate to the data flow that you want to run when either the primary or secondary data flow fails, then click Choose. If you leave this blank, then no action will be taken when either the primary or secondary data flow fails.
Alternatively, to send an email to a user or a group of users to alert them of the failed run, select Send Email and type the name or names of the recipients.
Tip: The option to send an email only applies to failed runs.Note: For the Send Email option to work, an Admin user must have already configured the email settings for all schedules. For more information, see Configuring schedule notification emails. - Select the Run Properties tab. You can configure run properties for each of the data flows in a chain. Select the Initial, On Success or On Fail data flow from the Data Flow list, then specify run property values as needed. For more information on run properties and run property sets, see Defining properties and Run property sets.