65.9K
CodeProject is changing. Read more.
Home

All the jobs in SQL Server

starIconstarIconstarIconstarIconstarIcon

5.00/5 (1 vote)

Aug 10, 2011

CPOL
viewsIcon

21430

If you want to list all the SQL Server jobs on your server and see which are enabled or disabled. This query will do it.
SELECT  a.job_id,
		a.name,
		a.description,
		a.date_created,
		a.date_modified,
		CASE a.enabled
			when 1
				then 'True'
			when 0
				then 'false'
			end
		as Enabled			
		
		
FROM   msdb.dbo.sysjobs a