Alerts related to SQL Jobs should show the job name not the job Id
Process name: SQLAgent - TSQL JobStep (Job 0xECCD1234543A1FA439B02DE3CE12F139E : Step 1)
-
Neil Reynard commented
Redgate Support team: I really appreciate your help in making this happen - in terms of monitoring, it has made a world of difference : thanks heaps.
-
Greg Smulko (Redgate) commented
Thanks @MM, good spot, I missed that. It'll be improved in v. 13.0.54.
-
MM commented
Thanks, i can see job name in blocking process and long-running alerts.
Could you also add job name to Deadlock (extended event) alert? There is still only job id.
-
Greg Smulko (Redgate) commented
We made this change for the blocking process alert. It was released in SQL Monitor v. 13.0.53 today.
This was already the case for other alerts (e.g., the long-running query alert).
I believe all the alerts show the job name now, but if that's not the case, please let us know. -
Neil Reynard commented
95% of blocking in our environment is done by any one of 300+ sql agent jobs - job id's provide very limited usefulness when looking into blocking in sql montior
-
Marco commented
Instead of replacing every mention of the ID, I would like to see the name additionally. Both information are useful.
-
Daniel Alexander commented
Just replace any mention of a job or steps with the name of the job or step, or both etc. I don't think this applies just to alerts about jobs, it should be system wide.