Introduction

Schedulers in ONE DATA are used to control the automatic execution of Workflows and Production Lines.

Using Schedulers, the user can trigger the execution of a Workflow or Production Line based on a time schedule or changes to a Data Table.


Creating a Schedule

A new Schedule can be created, by selecting "Create New Schedule" on the side panel in the Project Overview, or by navigating to the "Schedules" tab in the top navigation bar and selecting "Create New" on the side panel there.

This will open a window, where the user can select the Workflow or Production Line to be executed by the Scheduler, and its version. The version that is executed can be changed inside the Schedule later on.


Schedule Information

Once a Schedule has been created it can be accessed from the "Schedules" tab of the Project. This will open the Schedule Information. 



Here the user has the following capabilities:

  1. Like with most ONE DATA resources, the side panel allows to save, delete, or copy the Schedule. The Schedule can be renamed using "Edit Schedule Meta Info".

  2. The Schedule can be activated and deactivated with a single click. After creation, Schedules are deactivated by default.

  3. The version of the executed resource can be set to a specific version number or "latest" to dynamically use the latest version.

  4. The Scheduler Rules comprise the main execution logic of the Scheduler. There are two types of rules that can be created:

  • Event-based: When creating an event-based rule, the user has to select a Data Table, which triggers an execution when it is changed. Changes include append, create, delete, and modify.
    Additionally, a throttle time can be set to prevent the rule from being triggered for a certain amount of time after the event-based execution is finished. If there are changes to the selected Data Table during this time, a single execution of the rule will be triggered at the end of the throttle time (causing the timer to restart). The throttle time can still be altered after the rule is created.
  • Time-based: When creating a time-based rule, the user has to select a date and time for the first automatic execution, the frequency of future executions, and a stop condition.
    After the rule is created and added with the "+" icon, the options to edit or delete the rule will be displayed. Using the edit button, the frequency can be changed at any time after the rule was created. The stop condition can be changed as long as the Schedule has not been saved after the rule was added. The date and time for the first execution can be changed as long as said date and time have not passed yet.
  1. Instead of manually deactivating and activating a Schedule, there is the possibility to automatically pause the execution for a selected time period.

  2. The "Jobs" panel contains two tabs. The left tab shows the planned executions of all time-based rules in this Schedule, even if the Schedule is deactivated. The right tab shows the latest executions triggered by this Schedule.


Additional Information


Further Navigation

Within the Jobs of the selected Workflow/Production Line, if an execution was triggered by a Scheduler, an icon will appear next to that execution. Clicking this icon will navigate to the corresponding Schedule Information view.




Time Zones

When creating a time-based Scheduler Rule, the ONE DATA Client will display execution times in the time zone of the user's local machine. However, the ONE DATA Server will save the time as the corresponding UTC+00:00 time.

For example, if you create a Schedule to execute daily at 09:00 and your local machine is set to UTC+01:00, the ONE DATA Server will save the execution time as 08:00 in UTC+00:00. Time-based Scheduler Rules are always executed according to the time saved on the ONE DATA Server.
This means the execution time will not change due to time zone changes on the user's local machine, including seasonal variations like summer/winter time or daylight savings.

If in our example, the local time of your machine changes from UTC+01:00 to UTC+02:00 (i.e. application of summer time in Germany), the Schedule will still execute at 08:00 in UTC+00:00, which now corresponds to 10:00 on your local machine.


NOTE
The ONE DATA Client should automatically display execution times in the time zone of the user's local machine. In some cases, however, the time displayed in the Scheduler Rules might not adapt to local time changes resulting from summer/winter time or daylight savings. Regardless, the planned executions in the "Jobs" tab will always display the execution times correctly.