Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / database / SQL-Server

All the jobs in SQL Server

5.00/5 (1 vote)
10 Aug 2011CPOL 21.4K  
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.

SQL
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

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)