Earlier today I was experiencing issues with my PC and the GUI for SQL Agent jobs wasn’t appearing on screen. I really needed to stop a job that had become stuck over the weekend, so I turned to T-SQL and a system stored stored procedure. The code for releasing the stuck SQL Agent job is:
EXEC dbo.sp_stop_job N'Job Name or Job ID or Originating Server';
You must use msdb and then either the job name, job id or the orginating server. The orginating server will stop all jobs, so only use then when absolutely necessary.
Also of note, remember that the job might need to do a rollback and might not release straight away, so give it a little time and patience.