Post reply

List of SP's used on Jobs

  • June 11, 2009 at 3:56 am

    #131747

    Hi All

    I want to search for all the SP's that are been used by SQL Agent jobs, is there any way that i can get this information, apart from going through each job.

    Thanks for all your help

  • June 11, 2009 at 4:23 am

    #1007881

    SELECT command FROM msdb.dbo.SYSJOBSTEPS

    might be a helpful start point.

  • June 11, 2009 at 5:09 am

    #1007903

    Thanks , that will make my job a step easier, 🙂

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

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