What is the substitute for sp_helptask in sql server 2008 ?

• SQL Kidu

  Ten Centuries

  Points: 1296

  More actions

  May 6, 2009 at 12:28 am

  #200176

  Can anyone tell me what is the substitute for sp_helptask in sql server 2008 ? this was available in sql server 2000. so how i can get the same functionality in 2008 ? help me please.

• Ken Simmons

  SSCertifiable

  Points: 7822

  More actions

  May 6, 2009 at 7:20 pm

  #990088

  You can use the following stored procedures in the msdb database to get job information.

  sp_help_job

  sp_help_jobhistory

  sp_help_jobschedule

  sp_help_jobstep