title: How to kill a SQL Server job which keeps on showing an "In Progress" status?
body: <p>I am using SQL Server 2014 and I have a job (let's call it JN5) scheduled to run at a specific time on a daily basis. The job runs an SSIS package and has 11 steps in it. Looking at the Job History in SSMS, the job seems to be stuck at Step 9. It is not showing as a failure but "In Progress".</p>
  
  <p>I am having a hard time trying to stop it. I have tried the following:</p>
  
  <pre><code>USE msdb ; 
  GO      
  
  EXEC dbo.sp_stop_job N'JN5' ;  
  GO
  </code></pre>
  
  <p>I get the following error after execution:</p>
  
  <blockquote>
    <p>Msg 22022, Level 16, State 1, Line 2<br>
    SQLServerAgent Error: Request to stop job JN5 (from User sa) refused because the job is not currently running.</p>
  </blockquote>
  
  <p>Then, I tried the following: I restarted the SQL Server Agent through SQL Server Configuration Manager. When I viewed the SQL Job Status (after a Refresh) in SSMS, it was still showing "In Progress" !</p>
  
  <p>My next attempt to solve the issue was to restart SQL Server 2014. I then checked the status again in SSMS. It was still showing the "In Progress" status!</p>
  
  <p>I just had a look at the following on StackOverflow: <a href="https://stackoverflow.com/questions/40473611/sql-server-job-activity-job-failed-but-history-records-in-job-activity-still-sh">SQL Server job activity (job failed but history records in job activity still showing 'running' status)</a></p>
  
  <p>However, I am not sure if the above link relates to my problem. </p>
  
  <p>Any ideas on what I can attempt next?</p>