Search through SQL Agent Jobs (Поиск по джобам) #SQL

gistfile1.sql

    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
    
    URL: http://sqltidbits.com/scripts/search-sql-server-agent-job-steps-specific-keyword-text-or-stored-procedure