Here is a script that will show you the duration of each step for your jobs. this will give you a clue as to which step might be giving...

Great tip on the Activity Monitor, I did not realize you could use that.

If it is just the test environment, I use this script to kill connections prior...

I have this issue about once every 4 months. I pursued all of the permission issues and other things listed above. What I finally did was log into...

Everything above is good advice. I would add one thing. It might be a good idea to add and event notification so that you are emailed each time...

Since it appears to be happening during business hours, this might help. It is a script that shows what SQL statements are being consumed by the tempdb. You...

You might find this article extremely useful:

http://www.simple-talk.com/sql/t-sql-programming/database-deployment-the-bits---copying-data-out/

Here is a shot in the dark...

I had a similar error and I found that the Agent XPs wasn't enabled...

So I enabled it using this script:

sp_configure

'show advanced options', 1;

GO...

I agree that there is not enough information to determine the cause of the block; however, I ran your information through some analysis code that was posted by WayneS, which...

I work with several PowerBuilder developers and have the same issue. It is generally an open transaction on the tempdb. Tempdb will usually check point after I kill...