Search code examples
sql-serverssmssql-server-2016sql-server-agent

(SQL) Server Agent Job not stopping


I am using SQL Server 2016, and have some Jobs running in the SQL Server Agent. Today I found one of the job is taking too long (10hours!) to run and is still processing, so I try to stop that. I tried right-click and stop the job, it showed a success message. However, when I go to the Job Activity Monitor, it is showing that the job is still running! I also tried the following code:

USE [msdb]
GO
EXEC dbo.sp_stop_job N'Process Reserving MI (except problematic tables)' 
GO

It also says the job stopped successfully. But again when I go to the Job Activity Monitor, it is showing that the job is still running!

Can any one please help?


Solution

  • At the end I have to ask the server team to reboot the server in order to solve this problem