If it's hung in SQLAgent, you may not be able to do anything until you stop/restart agent (even with a kill). Take a look in the SQL Logs and see if there are any messages about non-yielding processes.
I'm going to split the points on this one. The first answer had the magic word "kill" in it. I looked this up in books on-line and found out how to kill a process. But, I didn't know what the hold-up was until I knew what I was looking at with the sp_who. Incidentally, I had been using sp_who to see the job but I didn't know about the block thing. Thanks,
0
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
eventually you may want to KILL the offending PID(s)
SP_WHO