FatalErr
asked on
How do you interrupt a job (or clear a connection) that is hung?
I'm running a DTS package on SQL 2000 that I scheduled to run under Agent. It still has a connection open but it isn't progressing.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
If I right click the job, what would I choose to see why it's being blocked?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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,
Brett