MSSQL – See status of running jobs
admin If you ever need to see the status of a running jobs, this TSQL can be very helpfull
job
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/