Retry scheduled job

• Richard Buchner, Chicago

  Ten Centuries

  Points: 1390

  More actions

  August 27, 2006 at 9:56 am

  #61789

  I have a job that runs every night at 3:00 a.m. it copies data from another SQL server, sometime it fails becuase of sporadic, netwrok problems. is there a way to retry the job several times, like every 15 mintues till it runs.

  i'm on slq 2000

   

  thanks

    

• August 30, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  August 30, 2006 at 9:30 am

  #657585

  You can set each step to retry as many time as you want with whatever interval you want. 

  Open the job properties in Enterprise Manager, edit the step, go to the 'Advanced' tab.  Set Retry Attempts and Retry Interval.

  Greg

  Greg

• Pankaj Khanna

  Say Hey Kid

  Points: 707

  More actions

  September 4, 2006 at 2:55 am

  #658274

  Greg is absolutely correct in his suggestion.

  I would like to add that you can configure the SQl Server Agent to sent you a notofication (through net send or mail) whenever the job fails/succeds.

  Best Regards

  Pankaj

  Pankaj Khanna
  Database Administrator - SQL Server 2000

  Keep hope to keep you intact...