List of SP's used on Jobs

• CrazyMan

  SSChampion

  Points: 12560

  More actions

  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

• iainthepitman

  SSCommitted

  Points: 1666

  More actions

  June 11, 2009 at 4:23 am

  #1007881

  SELECT command FROM msdb.dbo.SYSJOBSTEPS

  might be a helpful start point.

• CrazyMan

  SSChampion

  Points: 12560

  More actions

  June 11, 2009 at 5:09 am

  #1007903

  Thanks , that will make my job a step easier,