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