Planning a schedule¶
In this step you can generate one or more periodic schedules to run ETL incremental loads to keep the data warehouse aligned with the sources. Subsequently, during the scenario configuration, you can adapt the template created in this step to the actual scheduling of your plant. A summary of your settings is shown when you select the saved schedule in the "Schedules" tab.
Procedure¶
- On the Project page, select the "Schedules" tab.
- Click "Create Schedule".
- Insert a name for the schedule.
- Select the "Project Source" from which data should be loaded.
- In the "Frequency" area, select the frequency with which the ETL execution occurs.
- "Daily": Insert the number of days in the "Recurs every" box.
- “Weekly”: Insert the number of weeks in the "Recurs every" box and select the day(s) of the week when the ETL execution occurs.
- "Monthly": Select the occurrence type: "Day": insert a number from 1 to 31 in the "Day" box and the frequency in the "Recurs every" box, or "Custom" and select the following options:
- First, Second, Third, Fourth or Last.
- The corresponding day of the week or weekday/weekend day.
- The frequency in the "Recurs every" box.
- In the "Daily Frequency" area, from the "Frequency Mode" drop down box, select the occurrence frequency, which can be either "Once At" or "Every".
- Depending on this selection, do either of the following:
- Set the occurrence time in the "Occurs Once At" field.
- Insert the number of hours or minutes in the "Occurs Every" fields.
- In the "Duration" area, set a start date and optionally an end date.
- Click "Save".
Last update: October 26, 2026