Better "program name" for jobs in dm_exec_sessions
When reviewing session activity using sys.dmexecsessions, I see items in the program name column like:
SQLAgent - TSQL JobStep (Job 0x452FE49D5B63B84091F613691331151E : Step 6)
Yuck. On a busy system, I am expected to either memorize all these job representations, or write my own query that joins and figures out what job that really is.
If I capture session activity at a point in time, and then have to go re-query to figure out which job that is, I'm wasting potentially valuable time.
Upvotes: 1<=-=Jun 6 2007 12:40PM=-=>
Thanks for the report. We’ll investigate to see if a friendlier name makes sense….
-Richard Waymire<=-=Oct 31 2008 10:21AM=-=>
We are considering it for the next release,
Gil<=-=Jul 27 2009 9:54AM=-=>
Thank you for your feedback; but we won’t be fixing this for our next release.