Skip to main content

SQL Server query to Search SQL Agent Jobs by Name.

select job_id, name
from msdb.dbo.sysjobs
where name like N'%keyword%';

--
-- Additional....

-- To show the Job name and Category
select sysjobs.name as JobName,
    syscategories.name as CategoryName
from msdb.dbo.sysjobs
inner join msdb.dbo.syscategories
    on msdb.dbo.sysjobs.category_id = msdb.dbo.syscategories.category_id
order by sysjobs.name;