Search Job Command Text
Just want to start by saying SQL Search 1.1 is a very nice tool. I only have one issue kind of with it... it doesn't search Job Command Text. Is this something that can be added possibly?
We currently use the following query for searching & wondered if it could be put into SQL Search at all or be added to the "Others" object selector results:
SELECT j.job_id, s.srvname, j.name, js.step_id, js.command, j.enabled
FROM msdb.dbo.sysjobs j
INNER JOIN msdb.dbo.sysjobsteps js ON js.job_id = j.job_id
INNER JOIN master.dbo.sysservers s ON s.srvid = j.originating_server_id
WHERE js.command LIKE N'%' + @findText + '%'
Duplicate? http://redgate.uservoice.com/forums/101149-sql-search-feature-suggestions/suggestions/1468673-option-to-search-jobs - has 36 votes and counting...