title: How to stop a SQL job showing 'In Progress' status?
body: <p>I am using <code>SQL Server 2014</code> and I have a job (called ITB) which has been scheduled to run at 4.00am on a daily basis. The <code>SQL</code> 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.</p>
  
  <p>I have tried to stop the job by right clicking the job name in <code>SSMS</code> but I am getting the following message: </p>
  
  <pre><code>"Stop failed for Job 'ITB' (Microsoft.SqlServer.Smo)
  </code></pre>
  
  <p>I have also tried running the following T-SQL command in SSMS to stop the job:</p>
  
  <pre><code>USE msdb ;  
  GO  
  
  EXEC dbo.sp_stop_job  
  N'ITB' ;  
  GO  
  </code></pre>
  
  <p>I am getting the following message is SSMS:</p>
  
  <pre><code>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.
  </code></pre>
  
  <p>What is happening here and how can I deal with this?</p>