Option to search jobs
Frankly very surprised Version 1.0 didn't have this. Doesn't even seem like it would be a feature consideration. If you have a search tool, shouldn't it be expected to search the entire SQL Server, not just part of it? I wonder how many people assume it searches jobs, which after all are stored in a system database, and never realize they may be missing some references?
Anonymous
shared this idea
The new version of SQL Search now includes the option to search jobs. You can download v2 here:
http://www.red-gate.com/products/sql-development/sql-search/v2
Thanks for your suggestion – we are closing this so that votes are reallocated.
Thanks
SQL Search Development Team
-
Eric Isaacs commented
The trick isn't searching the job text as much as knowing if the job is applicable for the selected database you're searching. But even that information is in the job scripts. It seems that it would be one of the things that might be listed in the "Other" objects that SQL Search allows you to search in.
-
Eddie Groves
commented
This is really important for digging through large unknown legacy systems where a lot of "business rules" are hidden in SQL Jobs.
-
Stephen
commented
Duplicate? http://redgate.uservoice.com/forums/101149-sql-search-feature-suggestions/suggestions/1468673-option-to-search-jobs - has 36 votes and counting...
-
SteveRezhener
commented
Luke, I totally second you on that.
I see this shotsighted decision ammusing each time I see Developers think SQL Search does search through the jobs/job's steps. This happens about once a week and each time I need to come up with an excuse that explains how sql jobs are different from the real database objects. This usually ends up with SQL Search can't do that, but here is the script that does that.
I wonder how hard would be to add this piece of code?SELECT msdb.dbo.sysjobs.*
FROM msdb.dbo.sysjobsteps
INNER JOIN msdb.dbo.sysjobs ON msdb.dbo.sysjobsteps.job_id = msdb.dbo.sysjobs.job_id
WHERE command LIKE '%findme%'