In Enterprise Manager you can right click on the Job and select Stop Job. Here is a pertinent screen shot:
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?
Thank you for your question. If the job will not stop, you have three other options that are much more intrusive. These are:
- 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.
- 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.
- 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
Related Q&A from Jeremy Kadlec
Adding non-clustered indexes to SQL Server columns and tables frequently queried is possible. Learn how to add non-clustered indexes to SQL Server ... Continue Reading
Learn how to view a query execution plan in SQL Server with SQL Server Management Studio or Query Analyzer. Review and decrease query plan sub tree ... Continue Reading
Want to change the collation to SQL Server 2005 standards after upgrading databases from SQL Server 2000? Learn the best approach involving DTS and ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.