MSSQL – See status of running jobs

If you ever need to see the status of a running jobs, this TSQL can be very helpfull

SELECT sj.name
   , sja.*
FROM msdb.dbo.sysjobactivity AS sja
INNER JOIN msdb.dbo.sysjobs AS sj ON sja.job_id = sj.job_id
WHERE sja.start_execution_date IS NOT NULL
   AND sja.stop_execution_date IS NULL

Leave a Reply

Your email address will not be published. Required fields are marked *