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.  
LVL 1
FatalErrAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
LowfatspreadConnect With a Mentor Commented:
find out whats blocking it... under jobs...

eventually you may want to KILL the offending PID(s)

SP_WHO
0
 
arbertCommented:
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.

Brett
0
 
FatalErrAuthor Commented:
If I right click the job, what would I choose to see why it's being blocked?
0
 
arbertConnect With a Mentor Commented:
you run sp_who from query analyzer to see the block.....
0
 
FatalErrAuthor Commented:
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.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.