SQL Server's Fascinating Stories

Following query can be used to search through all the job steps for any Keyword. USE [msdb] GO SELECT j.job_id, j.name, js.step_id, js.command, j.enabled FROM dbo.sysjobs j JOIN dbo.sysjobsteps js ON js.job_id = j.job_id WHERE js.command LIKE '%Keyword_Search%' GO

The below script can be used to search a keyword in any of the existing Stored Procedures or Functions on any database. SELECT SPECIFIC_NAME, ROUTINE_NAME, ROUTINE_DEFINITION from INFORMATION_SCHEMA.ROUTINES where ROUTINE_DEFINITION like '%KEYWORD_SEARCH%'