How do you use cloud databases? Take the survey.
Options
Recording Agent Job duration
crimdon
Posts: 54 Bronze 3
I'd like to be able to record the duration of some of my SQL Agent Jobs. Was wondering if anyone else had done this in SQL Monitor and how they went about it.
I was thinking of maybe a custom metric but that would mean one per job.
I was thinking of maybe a custom metric but that would mean one per job.
Tagged:
Comments
You may be able to make use of the "Job duration unusual alert" as described in this article.
Otherwise you could possibly create a Custom metric if you can get a query to return the duration as a scalar value. That approach would probably be one custom metric per job.
I hope this helps!
Kind regards,
Alex
Have you visited our Help Center?