Query for finding command text within a sql server job

This code example demonstrates Sql programming techniques and best practices.

            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%'
        

Language: Sql
Original Source: BlogEngine.NET Migration
Code Lines: 16

Query for finding command text within a sql server job

select * from msdb.dbo.sysjobs j join msdb.dbo.sysjobsteps js on js.job_id = j.job_id where