About Me

My photo
MCTS FOR SQL SERVER 2008 DOT NET PROGRAMMING WEB DESIGNING

Monday, 17 February 2014

Search SQL Server Agent Job Steps for Specific Keyword Text or Stored Procedure

USE [msdb]
GO
SELECT j.job_id,
 s.srvname,
 j.name,
 js.step_id,
 js.command,
 j.enabled 
FROM dbo.sysjobs j
JOIN dbo.sysjobsteps js
 ON js.job_id = j.job_id 
JOIN master.dbo.sysservers s
 ON s.srvid = j.originating_server_id
WHERE js.command LIKE N'%KEYWORD_SEARCH%'
GO


No comments:

Post a Comment