SQL Server Agent Jobs List

To get a list of SQL Server agent jobs by category execute the following query:

SELECT j.[job_id], j.[name] [job_name], j.[category_id], c.name [category_name]FROM [msdb].[dbo].[sysjobs] jJOIN [msdb].[dbo].[syscategories] cON j.category_id = c.category_idORDER BY 2