To execute:
exec spJob_Dependencies
Output:
Job Name Type_Desc
Test_Load Addresses USER_TABLE
Test_Load Post_Codes USER_TABLE
fatal_dude09,
2015-07-29 (first published: 2015-07-02)
To execute:
exec spJob_Dependencies
Output:
Job Name Type_Desc
Test_Load Addresses USER_TABLE
Test_Load Post_Codes USER_TABLE
create procedure spJob_Dependencies as select database_name, Job, Name, Type_Desc, 1 as Has_Dep from ( Select a.database_name, a.name Job, b.name, b.type_Desc, charindex(b.name,a.command)as Has_Dep from (select js.database_name, j.name, js.command from msdb..sysjobs j inner join msdb..sysjobsteps js on j.job_id = js.job_id and js.database_name = DB_NAME() )a ,(select name, type_desc from sys.objects where type IN ('V','U','S','FN') )b)z where Has_Dep > 0 order by 1,3,2
The provided SSIS package contains a single script task that will script all SQL Server 2000/2005/2008 Agent Jobs into individual files.
2010-07-06
11,853 reads
Provides Stored Procedures and SSRS Report to show job status with details of errors.
Everyone has an opinion on the best advice to give an IT person who is unemployed and wants to get back into paid work. Phil Factor outlines what he would advise.
2009-07-16
213 reads
Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them
2008-12-30
4,305 reads
You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server
2008-12-16
3,346 reads