How to know procedure called by which SQL Job?

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

SQLZ SSChampion Points: 12872 More actions · Answer 1

Mahesh, try this:

declare @proc_name sysname

set @proc_name = 'enter proc name in here'

select j.name as job_name

from msdb..sysjobs j

join msdb..sysjobsteps s on s.job_id = j.job_id

where command like '%' + @proc_name + '%'

hope that helps,

Karl

mamidimahesh-127681 SSC Eights! Points: 868 More actions · Answer 2

SSC Eights!

Points: 868

July 17, 2006 at 12:31 am

Thanks Karl, it helped me

Mahesh