How can we improve SQL Search?

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?

61 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Luke JeffersonAdminLuke Jefferson (Admin, Red Gate) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Max AndersonMax Anderson shared a merged idea: Search Job Command Text  ·   · 
    started  ·  AdamAdminAdam (Admin, Red Gate) responded  · 

    We have started work to add the ability to search jobs. Our current plan is to have this as a separate option in the Objects dropdown.

    If you’d like to help us improve this feature by taking a short phone call or remote connecting to give feedback on our latest designs, please email us at usability@red-gate.com and we’ll get back to you with further details.

    4 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Eric IsaacsEric Isaacs commented  ·   ·  Flag as inappropriate

        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 GrovesEddie Groves commented  ·   ·  Flag as inappropriate

        This is really important for digging through large unknown legacy systems where a lot of "business rules" are hidden in SQL Jobs.

      • SteveRezhenerSteveRezhener commented  ·   ·  Flag as inappropriate

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

      Feedback and Knowledge Base