SQL – Check with statements that are blocked
admin You can check which statements are blocked by running this
TSQL
SQL Agent Job history – T SQL
Here are a Script, that you can use to extract the SQL Agent Job History This will also tell you the job steps Thanks to Chad Churchwell – https://www.mssqltips.com/sqlservertip/2850/querying-sql-server-agent-job-history-data/