Jobs not searched?

A free Management Studio add-in to search for SQL in your databases

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, Adam, justin.caldicott

Jobs not searched?

Postby GGinBerkeley » Fri Apr 12, 2013 12:41 am

I'm working on a new project, on a database that has many SQL Server jobs.

I had hoped that SQL Search could help me locate which jobs are calling out particular stored procedures (e.g., show me all jobs that invoke sproc 'foo').

Sadly, SQL Search seems to fail badly in this instance - jobs are completely ignored, apparently.

So I have had to resort to using this query instead:

use msdb
go
select sj.name as job_name, st.command
from sysjobs sj
join sysjobsteps st
on sj.job_id = st.job_id
where st.command like '%mysprocname%'


Are there any plans to change this? It seems like a major oversight/bug to not search for jobs.

Thx.
GGinBerkeley
 
Posts: 3
Joined: Fri Apr 12, 2013 12:29 am

Postby rre » Wed Aug 07, 2013 11:32 am

Yes, I agree to you.
Please, vote at this feature request site of SQL Search to move it up in the wish list.

http://redgate.uservoice.com/forums/101149-sql-search-feature-suggestions/suggestions/1468673-option-to-search-jobs
rre
 
Posts: 30
Joined: Thu Jul 07, 2011 2:13 pm

Postby Adam » Tue Feb 11, 2014 3:55 pm

We have started work on SQL Search for the forthcoming release and aim to add the ability to search jobs. Our current plan is to have this as a separate option in the Objects dropdown.

Thanks
Adam
Adam
 
Posts: 24
Joined: Tue May 27, 2008 1:40 pm
Location: Cambridge, England


Return to SQL Search 1

Who is online

Users browsing this forum: No registered users and 0 guests