Find All Enabled and Running Jobs in SQL Server


As a DBA sometimes we need to verify certain details for currently running jobs, jobs steps, jobs description and commands and queries used in jobs etc. We can extract these details by joining tables sysjobs and sysjobsteps and can find all Enabled and Running Jobs in SQL Server with a simple query.

SELECT database_name, name AS JobName, step_name AS JobStepName, 
enabled AS IsEnabled, description, command
FROM msdb.dbo.sysjobs SJ 
JOIN msdb.dbo.sysjobsteps SJS 
ON SJ.job_id = SJS.job_id
WHERE SJ.enabled = 1   --1 for enabled and 0 for disabled

On my test server it has returned below details.


Reference: Manzoor Siddiqui []

You may also like

You may also like...

Leave a Reply