select * from [Backup.Model.JobSessions] where [state] != '-1' Thos wil show you all jobs in a running state. I ran the below, after I made sure all my jobs were stopped. UPDATE [Backup.Model.JobSessions] SET [state] = '-1' WHERE [state] != '-1'