May 28, 2015 at 6:17 am
Is there a way to permanently change the order of the columns in Job Activity Monitor?
I'd like to move Duration to the right of Step Name, but this only lasts so long as I have JAM open. Once I close it and re-open, JAM goes back to its default column order. Google gives me nothing but the temporary "drag and drop" method that I already know about.
Does anyone know the name of the proc behind this? Maybe I could alter that.
May 28, 2015 at 7:40 am
Here is some good guidance on how to emulate job activity monitor programmatically:
http://www.sqlmatters.com/Articles/Checking%20the%20status%20of%20SQL%20Server%20Agent%20jobs.aspx
The undocumented procedure xp_sqlagent_enum_jobs can give you out the result set that you can manipulate.
MCITP SQL 2005, MCSA SQL 2012
May 28, 2015 at 11:16 am
RTaylor2208 (5/28/2015)
Here is some good guidance on how to emulate job activity monitor programmatically:http://www.sqlmatters.com/Articles/Checking%20the%20status%20of%20SQL%20Server%20Agent%20jobs.aspx
The undocumented procedure xp_sqlagent_enum_jobs can give you out the result set that you can manipulate.
At first glance, that is not what I want because I want to change the behavior of the activity monitor itself but just in the column order.
But I'll look more closely at this later when I'm done putting out current fires.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply