Dependencies of SQL Jobs?

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

Dependencies of SQL Jobs?

Postby psmith » Mon Apr 28, 2014 9:29 pm

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.
psmith
 
Posts: 4
Joined: Mon Apr 28, 2014 9:25 pm

Postby Brian Donahue » Wed Apr 30, 2014 11:18 am

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.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby David Atkinson » Wed Apr 30, 2014 12:29 pm

@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-de ... ql-search/
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby psmith » Wed Apr 30, 2014 6:47 pm

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.
psmith
 
Posts: 4
Joined: Mon Apr 28, 2014 9:25 pm


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 1 guest