I am trying to setup SQL Job Threshold Alert. We have a job in SQL that get stuck in loop we need to get notified if it running longer then normal.
Attached is my setup for the alert Added SQL Server and SQL Job to monitor. Next step I am no 100% sure we exactly you set the threshold alert.
I used the condition must exist for 25 minutes but I am not getting any alerts.
Thank you