Q
Problem solve Get help with specific problems with your technologies, process and projects.

SQL 2000 jobs running for days

I have SQL 2000 and some jobs are running for days. The status is 'performing completion actions.' How do I stop these jobs?

VIEW MEMBER FEEDBACK TO THIS ASK THE EXPERT Q&A.

In Enterprise Manager you can right click on the Job and select Stop Job. Here is a pertinent screen shot:

Figure 1

From a T-SQL perspective the command would be sp_stop_job. Another option to troubleshoot the issue would be to consider a third party product by the name of SQL Sentry. I have used the product, recommend it and think it could help troubleshooting the issue.


MEMBER FEEDBACK TO THIS ASK THE EXPERT Q&A:

I have tried your standard solution, but the job is still running with the status of "Performing completion actions." What's next?
—David C.

******************************************

Thank you for your question. If the job will not stop, you have three other options that are much more intrusive. These are:

  1. Issue sp_who2 in Query Analyzer to determine which process (spid) is running the job. Issue a KILL command for the particular spid. Reissue sp_who2 to see if the process is still running.

  2. When no other SQL Server jobs are running or scheduled to run, stop SQL Server Agent. This should stop the process internal to SQL Server. If the process is running in Windows, login to the SQL Server, start Task Manager, stop the Windows process such as a 32 or 16 bit application or a DOS session.

  3. During a maintenance window, stop the SQL Server service. This will definitely stop the process.

I hope this helps!
— Jeremy Kadlec, Performance and tuning expert


Do you have comments on this Ask the Expert Q&A? Let us know.

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close