9.7 Schedule Data Flows or Workflows

You can schedule workflows and data flows to run at specified time interval.

Each schedule allows you to specify a start date and time, and execution frequency.

To schedule a data flow or a workflow:

1. In the left pane, click Schedules.
2. Click Create Schedule.
3. From the Resource drop-down menu, select Data Flow or Workflow as appropriate.
4. From the Resource Name drop-down list, select a data flow or workflow that you want to schedule.
5. From the Frequency drop-down list, select the time frame in which you wish to execute the created schedule. You can schedule it On Startup, Simple, Daily, Hourly, Weekly, Monthly or Yearly. Based on the selected frequency, Time field appears allowing you to schedule the selected Data Flow or Workflow. For detailed information refer to the below table:

   Frequency	Time Values
   On Startup	NIL
   Simple	Click Select Date Time icon next to Date and Time field, to select the required date and time in MM/DD/YY and HH:mm format.
   Daily	Click the clock icon next to Time field, to select the required time in HH:mm format.
   Hourly	Click up and down arrows next to Time field, to select the required time in Minutes:Seconds format.
   Weekly	Run Every parameter appears with check-boxes for all the days of the week. Click the clock icon next to Time field, to select the required time in HH:mm format.
   Monthly (day of the month)	Select the required date from the Monthly Date drop-down box. Click the clock icon next to Time field, to select the required time in HH:mm format.
   Monthly (week day)	From the Monthly date drop down box select the required value. From the Week day drop-down box, select the required weekday in which you wish to schedule the job.
   Yearly	From the Month drop down box, select the required month in which you wish to schedule the job. From the Monthly date drop down box, select the required date in which you wish to schedule the job. Click the clock icon next to Time field, to select the required time in HH:mm format.

6. In the Number of Attempts on Failure text box, enter the required value or click the up or down arrows next to the text box, to select the required value. This value denotes the number of retry attempts that should happen after the schedule failure.
7. Stop Execution After field denotes the time after which the schedule has to stop after executing it. It can be in Hours, Minutes or Seconds. Select the value and its unit.
8. Select the status of the scheduled Data Flow or Workflow from the Status options. It can be Active, Inactive or Active for Period. Through Active for Period option you can configure the exact time frame of the created schedule. It's Starting and Ending Date with time, time interval in which you wish to run the schedule and exceptions, if any.
9. After configuring the above details, click Save.

   The created schedules get listed in the Schedules page along with the following details:

   • Resource
   • Status
   • Frequency
   • Valid or Invalid
   Click the Actions menu () of the respective schedule to perform the following operations:
   • Click Edit to edit the details of the created schedule.
   • Click Disable to disable the created schedule. The status of a schedule becomes inactive when you disable it and gets displayed in the Scheduled list. Select the schedule and click Enable, to enable it whenever required. You can enable it again for a specific period, through Enable for Period option.
   • Click Validate to validate the created schedule.
   • Click Delete to delete the created schedule. Upon confirmation the created schedule is deleted.

To schedule a data flow or a workflow specific to a project:

• Click the Project title displayed on the Projects page.

  Project Details page appears.

• In the left pane, click Schedules.

  Schedules page appears. It displays all the schedules pertaining to the selected project.

  Note:

  This page is project specific and displays only the Data Flows and Workflows pertaining to the selected project.
• To create a new schedule, click Create Schedule.
• Enter all the required details and click Save.

  The new schedule is created and is added to the existing list of schedules for the project.