Query for finding command text within a sql server job 26 October 2015 Don-Rickman SQL Server - T-SQL (0) select * from msdb.dbo.sysjobs j join msdb.dbo.sysjobsteps js on js.job_id = j.job_id where command like '%reporting_drop_ship_orders%'