Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

(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?

like image 456
J.Cheuk Avatar asked May 12 '26 20:05

J.Cheuk


1 Answers

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

like image 89
J.Cheuk Avatar answered May 14 '26 12:05

J.Cheuk