Scheduling the execution of data jobs
Schedules are used to automatically execute data jobs on a predefined basis, allowing you to control the day, time of day, and repetition of your executions.
By default, schedules run sequentially, meaning that they attempt to successfully execute each task before moving on to the next. If a task fails to execute, all remaining tasks are canceled.
When scheduling your data jobs, you have two options:
Frequency based scheduling: This allows you to manually define when your data jobs are executed based on day, time of day, and repetition of the execution. See: Creating frequency based scheduling of data jobs.
Trigger based scheduling: Using trigger based scheduling of your data jobs, the successful execution of one schedule of data jobs automatically triggers another schedule to run. See: Configuring trigger based scheduling of data jobs.
Creating frequency based scheduling of data jobs
To create a standard schedule for your data jobs from your data pool diagram:
Click Schedules.
Click Add Schedule, add a schedule name, and then click Create.
Configure your schedule using the following options:
Load type: Select from full or delta loads.
Schedule plan: Select from hourly, every few hours, daily, weekly, monthly, or custom cron and then enter the time or date frequency. For more information about the custom cron, see: Custom cron syntax.
Add data jobs: Select which data jobs should be included in this schedule and then order them in sequential order (with the top job running first and so on).
Execute: Manually execute the existing configuration of this schedule.
Enable / disable schedule: Select if this schedule is live, with the schedule running at the next configured time or date.
Enable / disable monitoring: Select if this schedule should contribute to your data job monitoring.
The schedule is now configured and can be managed and edited from your scheduling overview page by clicking Options.
Configuring trigger based scheduling of data jobs
Limited availability
This functionality is currently in limited availability. If you’re interested in trying it out, get in touch with us through celopeers.com/s/support.
Trigger based schedules allow you to choose a schedule to serve as a trigger from any data pool within your Celonis Platform team and then select a target schedule to be triggered. This allows you to orchestrate schedules across data pool.
To configure trigger based scheduling:
Open the schedule to be triggered and select the Trigger-based schedule radio button.
In the Scheduling Trigger section, click the + Add Schedule button and then select the schedule to use as a trigger.
Click Save.
The new trigger-based schedule displays in the Scheduling Trigger section and shows additional information such as the current status and the next scheduled execution.
Custom cron syntax
The cron syntax allows you to precisely define a custom scheduling plan. The syntax is composed of six elements, with each element either a number or an asterisk for "every":
Second: 0-59 or *
Minute: 0-59 or *
Hour: 0-23 or *
Day of the week: 1-7 or SUN-SAT or */?
Day of the month: 1-31 or */?
Month of the year: 1-12 or JAN-DEC or *