Need custom metric for long running jobs

jgraves

I found a custom metric for a single long running job. However, what we need is a way to alert for SQL Agent jobs that are running beyond a designated time (similar to the long running query metric built in). The "unusual duration" alert doesn't quite do what we need. Hopefully someone knows how to make this a custom metric. If not, consider a feature request!

Thanks in advance, Jay

Russell D

We've had requests for this sort of thing in the past; I'll pass the feedback on to the rest of the team. In the meantime I'd recommend posting it on the uservoice: https://sqlmonitor.uservoice.com.