How to stop a SQL job showing 'In Progress' status?
Restart SQL Server Agent
In Object Explorer, connect to the instance of the Database Engine, right-click SQL Server Agent, and then click Start, Stop, or Restart.
If the User Account Control dialog box appears, click Yes.
When prompted if you want to perform the action, click Yes.
user3115933
Updated on July 21, 2022Comments
-
user3115933 almost 2 years
I am using
SQL Server 2014
and I have a job (called ITB) which has been scheduled to run at 4.00am on a daily basis. TheSQL
job has 11 steps in it. At 09.00 am this morning, I noticed that the job was showing 'In Progress' in the job history. It seems to be stuck at Step 8 of 11.I have tried to stop the job by right clicking the job name in
SSMS
but I am getting the following message:"Stop failed for Job 'ITB' (Microsoft.SqlServer.Smo)
I have also tried running the following T-SQL command in SSMS to stop the job:
USE msdb ; GO EXEC dbo.sp_stop_job N'ITB' ; GO
I am getting the following message is SSMS:
Msg 22022, Level 16, State 1, Line 2 SQLServerAgent Error: Request to stop job ITB (from User sa) refused because the job is not currently running.
What is happening here and how can I deal with this?
-
Larnu almost 6 yearsSounds like you haven't refreshed the Agent Job window.
-
Sameer almost 6 yearsRefused because the job is not currently running.
-
-
Larnu almost 6 yearsThat may not be the best of ideas. If the OP has any other jobs running at the time they will be cancelled and won't be restarted. If you're going to recommend something like that, you should include such warnings.