T-SQL: Jobs in suspended state
It is possible that sql jobs are “hanging” in a suspended state. The SQL statements below will give you an indication on what the job is waiting.The first SQL statement will create a small stored procedure in the master database, which can be called by “exec sp_check_state”.The second sql satement…