Adding SQL Jobs to Long running alert
We have alerts coming into Production operations TEAM channel for long running SQL jobs.
e.g.
[09:30] sqlmail@accelins.com
Warning: Potential Long running SQL Agent jobs
JobName
JobID
RequestedDate
StartDate
LastExecutedStepDate
LastExecutedStep
JobDurationMins
Threshold
OverdueMins
Source Staging Loads
2AC6850B-8EE5-4122-AA17-EEE8F66CC278
2023-04-11T08:00:00
2023-04-11T08:00:01
2023-04-11T08:00:23
Intrali Full Table Load
90
70
20
How to add a new SQL job to be monitored
If we need extra jobs adding to those monitored all we need to do is add a config row to the following table
The JobID is the guid of the SQL agent job.