August 15, 2012 at 11:31 pm
Hi All,
I have a stored procedure "SpTestProcedure" in SQL server 2005, i need to check the dependencies of that procedure in the SQL jobs.Because we are having around 100 SQL jobs hosted in the server.
Please do needfull. How to search the"SpTestProcedure" is used in any of the SQl server job steps?
August 15, 2012 at 11:45 pm
select j.name
from msdb.dbo.sysjobsteps s
inner join msdb.dbo.sysjobs j
on j.job_id = s.job_id
where s.command like '%SpTestProcedure%'
August 16, 2012 at 1:44 am
Thanks for your response..
msdb.dbo.sysjobsteps & msdb.dbo.sysjobs is able to access only by administrators and not by developers. Could you please give me some hints to check the procedures dependencies in SQL jobs for developers?
August 16, 2012 at 3:25 am
I am not aware of any other method. Others might know.
Meanwhile you can ask the administrators to help in this matter.
August 16, 2012 at 4:23 am
This is administrator information. Either you need to get view server state permissions or you need to work with someone who does.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply