How can we help you today? How can we help you today?

Need custom metric for long running jobs

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
jgraves
0

Comments

1 comment

Sort by
  • 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.
    Russell D
    0

Add comment

Please sign in to leave a comment.