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: 397721
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply