AVB (11/20/2009)
Bru,Yes you are correct... however there can be many jobs running at any one given time. I could see what jobs are running by using the Job Activity Monitor but I need to know the specific one that is causing the high wait time.
Hi,
Please follow the link below to my article on this topic. It would have been a huge reply, so I made an article and I am providing link below.
Find a SQL Agent Job Name based on the Activity Monitor[/url]
Edited to inlcude the new URL for the blog...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty