Scheduling Objects in Jet Analytics Orchestration
Schedule Groups are used to schedule automatic executions of objects in Jet Analytics Orchestration. Almost any type of object can be scheduled: Processes, Packages, Queries, Compare Queries, Reports, Dimensions, and Object Groups.
Create a Schedule Group
- Right-click Orchestration > Schedule Groups.
- Select New > Schedule Group.
An empty Schedule Group has three main areas:
- Objects currently in the schedule
- Schedule trigger configuration
- Objects available to add to the schedule
Schedule triggers
A schedule trigger is a rule that determines when a Schedule Group executes. When a trigger fires, all included objects execute simultaneously on the environment (Development, Test, or Production) defined in Execute on.
One Time trigger
Executes the Schedule Group once at a predefined date and time in the future.
Repeat Every trigger
Executes objects on a repeating interval — for example, every 10 minutes during office hours or every hour overnight. The first trigger is calculated from the start date.
Daily trigger
Executes every day or on weekdays only, at a predefined time. Can also be configured to execute every other day or on a specific day interval.
Weekly trigger
Executes on selected days of the week — for example, Monday, Wednesday, and Friday.
Monthly trigger
Executes on selected months, with the choice of specific calendar dates or specific days of the week within a month — for example, the first and third Monday of every month.
Custom trigger
The most flexible trigger type, used when the other trigger types cannot meet the scheduling requirements. A custom SQL query is written that returns the next execution date and time. This can be used, for example, by financial institutions that need to execute on banking days only — the query filters out dates by comparing them to a bank holiday table.
Example: if you have a date table named dbo.ExecutionDates, the following custom SQL query returns the next scheduled execution date:
SELECT TOP 1 ExecutionDate FROM dbo.ExecutionDates WHERE ExecutionDate > @LastRun AND ExecutionDate > DATEDIFF(min, -5, GETDATE()) ORDER BY ExecutionDate
Click the Help button within the Custom trigger dialog for detailed information about the available options and parameters.
Add objects to a Schedule Group
To add objects to the schedule, find the desired object in the Object/Item browser on the right and drag it into the schedule list, or double-click it.
Parameters can be added to each object and will be passed through on execution. For example, --autocreateusers can be added to a query to create users not found through user mapping, or --email example@example.com can be added to receive email notifications about execution results.
All objects in a Schedule Group execute simultaneously, which can place unnecessary load on source systems. If multiple objects do not need to start at precisely the same moment, add them to an Object Group first and then add the Object Group to the schedule. Object Groups allow execution to be controlled in sequential steps, reducing concurrent load.
Add objects via the properties pane
Objects can also be added to a Schedule Group directly from the object's properties pane. Open the object and select the desired Schedule Group from the list of available groups.
Schedule overview
An overview of all Schedule Groups — including last and next execution times — is available in the Schedule Groups folder.