sql jobs

• mnagasrikanth219

  SSC Veteran

  Points: 269

  More actions

  July 20, 2011 at 6:23 pm

  #244543

  I have a BUNCH of sql servers and in them for a "paricular job" i need to find out the RETRY INTERVAL of that "particular job"?Is there any query to find the retry interval(time) of a "particular job" in bunch of servers?

  Help would be appriciated really!!!!!!!!!!!!!!!

  Thanks a tone in advance

• Jannie-186227

  SSCrazy

  Points: 2319

  More actions

  July 20, 2011 at 9:43 pm

  #1356131

  Hi

  Checkout the sp_helpjob & sp_helpjobstep.

  They are system functions, and you can use them with job name or id.

  Cheers

  Jannie