Search SQL Agent Job using Specific keyword text or SP - 2000\2005\08\08R2\12\14\16\17\19

SQL Server 2000 Job Step Search

USE [msdb]

GO

SELECT    jb.job_id,

       jb.originating_server,

       jb.name,

       js.step_id,

       js.command,

       jb.enabled

FROM    dbo.sysjobs jb

JOIN    dbo.sysjobsteps js

       ON    js.job_id = jb.job_id

WHERE    js.command LIKE N'%KEYWORD_SEARCH%'

Search SQL Server Agent Job Steps for Specific Keyword Text or Stored Procedure-2005\08\08R2\12\14\16\17\19

SELECT 

       jb.job_id,

       js.srvname,

       jb.name,

       js.step_id,

       js.command,

       jb.enabled

FROM    msdb.dbo.sysjobs jb

JOIN    msdb.dbo.sysjobsteps js

       ON    js.job_id = jb.job_id

JOIN    master..sysservers s

       ON    js.srvid = jb.originating_server_id

WHERE    js.command LIKE N'%KEYWORD_SEARCH%'

GO