Making SQL Agent re-execute job upon failure

• DataGuy

  SSCrazy

  Points: 2029

  More actions

  June 11, 2010 at 11:49 am

  #233641

  Hi,

  I have a job that fails every now and then because of the system timing out due to various reasons. I'm looking for a way to make the job re-run itself automatically if it fails. What is the best way to accomplish this>?

  TIA

• Grant Fritchey

  SSC Guru

  Points: 399289

  More actions

  June 11, 2010 at 12:48 pm

  #1179389

  You can go to the advanced tab for the given step in the Agent job and tell it to retry a set number of times.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning