SCRIPT: How to find string in Ssteps of SQL Server Agent Jobs

on
 USE msdb
 
GO
 SELECT Job.name          AS JobName,
       Job.enabled       AS ActiveStatus,
       JobStep.step_name AS JobStepName,
      JobStep.command AS JobCommand
 FROM   sysjobs Job
       INNER JOIN sysjobsteps JobStep
               ON Job.job_id = JobStep.job_id
WHERE  JobStep.command LIKE '%YOUR_STRING%'

Comments

Post a Comment