Hello, I'd like to request the ability to be notified if specific daily SQL jobs are running significantly longer than normal (perhaps using an average of the last 4 instances of that job's performance over whichever day of the week it is). In DevOps tab for SQL Server we can see the all-up success/failure ratio...but we cannot drill down any further than this to get more relevant information.
In addition, I would like to be able to drill down to the task level within the Job itself, and know which step specifically is causing the slowness.
This will increase the value of our Site 24x7 in our organization, significantly. Thank you!