Script to get Job Name from Command

This script helps to get a job name from command or job script.

If you remembered only one word that you have used in your job script and you want to get a job name, this script helps you.

Just paste your word instead of “AnyOneWordFromJobScript”.

USE MSDB
GO

SELECT Sj.Name As JobName,
       St.Command As JobScript
FROM   Sysjobs Sj
       JOIN Sysjobsteps St
         ON Sj.Job_id = St.Job_id
WHERE  St.Command LIKE '%AnyOneWordFromJobScript%' 

Regards,

Nirav Gajjar