Need to get the StoredProcs\Queries used by the sql Jobs in server

Question

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

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

Nabha SSCrazy Eights Points: 8534 More actions · Answer 1

Interview huh?

USE MSDB

Select SJS.command

from msdb.dbo.sysjobs SJ

JOIN sysjobsteps SJS ON SJ.job_id = SJS.job_id

WHERE SJ.Enabled = 1

Order by SJ.NAME DESC

---------------------------------------------------------------------------------

pols SSC Eights! Points: 935 More actions · Answer 2

No this is not an interview question.:)

This is my TL requirement.:(

Anyhow thanks for your reply.

Another way to get :

SELECT DISTINCT SPROC=SPECIFIC_NAME

FROM [msdb].[INFORMATION_SCHEMA].[ROUTINES]

CROSS JOIN msdb.dbo.sysjobsteps

WHERE Command like ('%'+SPECIFIC_NAME+'%')