Search-SQL.sql

-- search the jobs for a specific text 
select
  [InstanceName] = serverproperty('servername')
  , j.job_id
	, j.name
	, js.step_id
	, js.command
	, j.enabled 
from
  msdb.dbo.sysjobs j
  join msdb.dbo.sysjobsteps js on
    js.job_id = j.job_id 
where
  js.command LIKE '%sometext%' -- replace keyword with the word or stored proc that you are searching for
  
-- search the sql code
select
	routine_name
	, routine_definition
	, routine_type
from
	information_schema.routines
where
	routine_definition like '%sometext%'