DECLARE @SearchString varchar(255),
@IsEnabled bit;
SET @SearchString = 'history';
-- Enter Search String Here. Leave Blank for All
SET @IsEnabled = 1; -- 0 = Disabled, 1 = Enabled, 2 = All
SELECT j.Name JobName, j.Description JobDescription,
js.step_id StepID, js.step_name StepName,
js.database_name DatabaseName,
js.command StepCommand ,*
FROM
msdb..sysjobs j INNER JOIN msdb..sysjobsteps js ON
j.job_id = js.job_id
WHERE (j.enabled = @IsEnabled OR @IsEnabled = 2) AND js.command LIKE '%' + @SearchString + '%'
ORDER BY j.Name, js.step_id;