I have SQL server, where are 6 SQL jobs and it's configured to write events to Windows journal every time when job is finished (it does not matter successfully or unsuccessfully).
Normal behavior is that events appears every 5 min for one job, 15 min for another, 7 min for another and etc (duration between events can be with a small deviation).
But sometimes, jobs can halt for a long time, therefore events will not appear.....
I need to setup an alert for such incidents, i.e. find deviation from normal behavior.