I wonder why I couldn't find a script on the Internet which generates statements to execute all jobs in the same job category. The only reason I could think of is that it's simple to write so here goes my version SET NOCOUNT ON USE tempdb GO DECLARE @Category AS VARCHAR ( 255 ) SET @Category = 'Database Maintenance' SELECT a . name...