Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.
Solved
How do you interrupt a job (or clear a connection) that is hung?
Posted on 2004-03-30
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
5 Comments
find out whats blocking it... under jobs...
eventually you may want to KILL the offending PID(s)
SP_WHO
eventually you may want to KILL the offending PID(s)
SP_WHO
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
Brett
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,
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article explains how to reset the password of the sa account on a Microsoft SQL Server. The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL).
Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses
Course of the Month11 days, 5 hours left to enroll
618 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.