Red Gate forums :: View topic - Dependencies of SQL Jobs?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

Dependencies of SQL Jobs?

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
psmith



Joined: 28 Apr 2014
Posts: 4

PostPosted: Mon Apr 28, 2014 9:29 pm    Post subject: Dependencies of SQL Jobs? Reply with quote

Hi there,

We are using the trial of SQL Dependency Tracker 2 and was curious if there is a way to see dependencies of SQL Server Jobs.

For instance, some of our jobs have steps that have SQL code inside the step. These steps may reference a Table/View/Stored Procedure.

Hope this makes sense.

Thank you for the help.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6673

PostPosted: Wed Apr 30, 2014 11:18 am    Post subject: Reply with quote

Unfortunately not. SQL Dependency Tracker only works at database-level and not with server-level attributes like SQL Server Agent jobs and logins.

Even if you did try to point it at the MSDB database, it would ignore system objects, so you probably wouldn't get much use out of it in that way.

There is probably another product out there that manages jobs and can show these dependencies.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Wed Apr 30, 2014 12:29 pm    Post subject: Reply with quote

@psmith,

You might want to try SQL Search 2 (free tool), which can search your Jobs for an arbitrary piece of text

http://www.red-gate.com/products/sql-development/sql-search/
Back to top
View user's profile Send private message Send e-mail
psmith



Joined: 28 Apr 2014
Posts: 4

PostPosted: Wed Apr 30, 2014 6:47 pm    Post subject: Reply with quote

Thank you all for the replies.

While I do like SQL Dependency tracker;

In my humble opinion, if the functionality was added to SQL Dependency Tracker to see Jobs and DTS/SSIS packages the software would be invalueable to us.

We have hundreds of jobs and DTS/SSIS packages and finding all references to a certain DBO object can be a real pain.

For example, this tool is great for finding all the tables a specific Stored Procedures touches. However, we also need to see the Jobs and DTS packages that the Stored Procedure references. That would be so helpful.
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