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.
Yes I agree...
I found a work around which might not be the best possible one. Currently working on it, will post here as soon as I am done.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty