Click here to Skip to main content
15,887,974 members
Articles / Database Development / SQL Server
Tip/Trick

All the jobs in SQL Server

Rate me:
Please Sign up or sign in to vote.
5.00/5 (1 vote)
10 Aug 2011CPOL 21.3K  
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)


Written By
Software Developer
United Kingdom United Kingdom
SQL Server developer and a geek

Comments and Discussions

 
-- There are no messages in this forum --