Scheduling Objects (Tutorial)

Schedule Groups are used in exMon to schedule automatic executions of objects.

This tutorial covers the following topics:

 

 

Creating Schedule Groups

To create a new Schedule Group, right click exMon > Schedule Groups, and choose New > Schedule Group.

1_New_Schedule_group

 

 

An empty Schedule Group has three main areas; Objects currently in schedule, Schedule Trigger and Objects available for schedule.

2_Empty_Schedule_Group

 

 

Schedule Triggers

A schedule trigger is a rule that determines when the Schedule Group will execute. For example, it could execute every 5 minutes between 9 am and 17 pm, or it could execute first Sunday every month at 9 am.

When a schedule trigger executes, it executes all included objects at the same time on the environment (Development, Test, Production) defined in Execute on.

 

There are multiple ways of configuring schedule triggers. Here are some of the most common:

 

One Time Trigger

3_SG_one_time

As the name suggests, the One Time trigger executes the Schedule Group once, at a predefined time in the future.

For example, in the case above, the Schedule Group would execute on the 15th of April 2015, at 9 pm.

 

 

Repeat Every Trigger

4_SG_repeat_every

Repeat Every allows you to execute objects on an interval. For example, every 10 minutes during office hours or every hour during then night.
The first trigger is calculated from the start date.

 

 

Daily Trigger

5_SG_daily

The daily trigger is probably our most common used trigger. With the daily trigger you can configure the trigger to execute every day or weekday, at a predefined time. In our example the trigger is configured to execute every weekday at 9 pm, starting at April  15th 2015.

With the daily trigger, it is also possible to have for example, execute every other day.

 

 

Weekly Trigger

6_SG_Weekly

With the Weekly trigger, you can choose which days in a week to execute. For example if you need to execute on Monday, Wednesday and Friday every week.

 

 

Monthly Trigger

7_SG_Monthly_1

With the monthly trigger you choose which months are enabled, and choose between specific days in a month or days of a week.

For example, in our example above, we have (for some reason) chosen to execute on the 2nd and 7th of January and February at 9 pm.

 

7_SG_Monthly_2

In this example, we have chosen to execute on the first and third Monday of every month, at 9 pm, starting from April 15th.

 

 

Custom Trigger

8_SG_Custom

Custom triggers is without a doubt our most complex trigger and can be used when the other triggers can’t fulfill the requirements.

With the custom trigger, you create a custom SQL query which returns when the schedule should execute. This can, for example, be used by financial institutions to execute on all banking days. In that case, the query could filter out executions by comparing dates to a bank holiday table.

 

8_SG_Custom_Help

The help button provides detailed information about Custom triggers.

 

 

 

Adding objects to schedule

Almost every type of objects in exMon can be added to a Schedule Group, they include:  Processes, Packages, Queries, Compare Queries, Reports, Dimensions and Object Groups.

9_object_explorer

To add objects to schedule, find the desired object in the Object/Item browser and drag it to the schedule list, or double click it.

 

10_scheduled_objects

You can add parameters to each object, that will be passed down when executing. In our example, we have added “–autocreateusers” to the Sales Without Price query to make it create users not found through user mapping. It is also popular to add “–email example@example.com” to notify about the results with email.

 

Important note: All objects in Schedule Groups are executed at the same time which can put unnecessary load on source systems .
If you have multiple objects that don’t depend on starting exactly at that moment, it is good practice to add those objects to an Object Group and add that Object Group to the schedule. With the Object Group you are able to control executions into steps.

 

 

 

Adding objects to schedule through property grid

Objects can also be added to a Schedule Group in the properties pane within the object.

Here is an example of a properties pane from a Compare Query where it is possible to can choose between all available Schedule Groups.

11_SG_within_an_object

 

 

 

Schedule Overview

An overview of Schedule Groups, with their last and next execution can be found in the Schedule Groups folder in exMon.

12_SG_overview

 

Here we can see the current status of all Schedule Groups on the AdventureWorks system.

12_SG_overview_2

exMon Contact Us