Hourly Thresholds

[brhenso]

Hello,

I am trying to make a threshold that checks the specified indicator, hourly and then send a notification when it is reached.

I created a threshold and indicator, where the indicator source has a job that runs hourly. This makes the graph on the dashboard update hourly, which is good.

However when it comes to sending out a notification it only sends at the end of the day, so there could be many hours between the end of the day and when the threshold is reached that the team is missing.

I researched that the scheduled job 'Check PA Thresholds' checks for if a threshold is reached and then sends out the notification 'PA Threshold Reached'. When I set this scheduled job to run on an 'interval' or 'repeat' instead of 'daily' it does not send a notification at all.

I am wondering if it is possible to have hourly thresholds notifications?

Thank you for your help in advance.

-Brady Henson

[mike_bush]

It should be possible to achieve what you want - you just need to knit the whole story together.

Out-of-box, on a DAILY basis :-

1. Data collector job gathers SCORES

2. Threshold job spots any breaches, plants two types of EVENT - one says "Some breaches" allowing a summary mail to be sent, other says "Specific breach" allowing individual mails to be sent to interested parties.

3. NOTIFICATIONS pick up on the events

You just need to ensure that AFTER your hourly collection you have a threshold job which plants suitable events - and maybe you DON'T use the summary notification? (or maybe you do if the thresholds are really important to you?)

[brhenso]

Thank you Mike for the response.

Correct, I do not want to use the summary notification. Which it was working when the 'theshold job' (Check PA Thresholds) was daily, but not when I changed it to an Interval trigger type it stopped sending notifications.

As you mentioned above a, "Threshold job spots any breaches, plants two types of EVENT". Do you think when I changed it to an Interval trigger type it calls another event which would trigger the summary notification?

I have the 'data collector job' running every hour on the hour and the 'theshold job' running thirty minutes after the hour, every hour.

Thank you again for the help Mike.

-Brady

[sandra_villarre]

Setting "Check PA Threshold" to run on an hourly basis is currently not available OOB.

OOB the column pa_threshhold.last_check contains the date when the last threshold was checked. It is an integerdate, therefore it will only send out notification on the next day.

The column "Last check" can be found on the pa_thresholds table or by navigating to Performance Analytics > Indicators > Thresholds.

On the list view you may need to personalize the list and add the column "Last Check."   The column is filled in with the current date (without time component).

If this field is populated, then the job "Check PA Thresholds" will not process the thresholds again for the same day.

Clearing the field will cause the "Check PA Thresholds" to reprocess these thresholds.

Workaround:

The workaround would be to write a business rule or have a scheduled job clear out the 'last_check' every hour. From there, the 'Check PA Thresholds' scheduled job can be set as you as interval of every hour.