where can I find this stored procedure?

• Niranchanadevi Rajmohan

  Newbie

  Points: 1

  More actions

  February 28, 2007 at 12:58 pm

  #172279

  Hi

  I would like to a stored procedure(msdb.dbo.sp_help_job - I found this when I ran a trace) in my application. Before using it I would like to debug this stored procedure and know about input and output values.

  I am trying to locate this in SQlserver 2000 Enterprise Manager -but couldnt find it. Can any one please let me know where to find this...

  thanks

  -Niranch

• pinky

  SSCommitted

  Points: 1997

  More actions

  February 28, 2007 at 1:46 pm

  #692418

  you can find this stored procedure in msdb database. this is a system stored procedure

• Scott Coleman

  One Orange Chip

  Points: 27452

  More actions

  March 1, 2007 at 6:41 am

  #692564

  The best place to find info about this and other system stored procedures is in Books Online.  Just look up sp_help_job in the index.