Red Gate forums :: View topic - Jobs not searched?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Search 1
SQL Search 1 forum

Jobs not searched?

Search in SQL Search 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
GGinBerkeley



Joined: 12 Apr 2013
Posts: 3

PostPosted: Fri Apr 12, 2013 12:41 am    Post subject: Jobs not searched? Reply with quote

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.
Back to top
View user's profile Send private message
rre



Joined: 07 Jul 2011
Posts: 30

PostPosted: Wed Aug 07, 2013 11:32 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Adam



Joined: 27 May 2008
Posts: 24
Location: Cambridge, England

PostPosted: Tue Feb 11, 2014 3:55 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group