May 23, 2008 at 11:37 am
I have a job that runs 8:00 am daily, but it requires to look at a remote database onboard a ship. Unfortunatly the ship is not always back in range of the wireless so the database may or may not be available.
Is there a way to check the availability of the connection to a remote SQL server and if unavailable reschedule the job, or at the least automatically reschedule (For maybe 1 hour later) if the job fails?
Thank you,
May 23, 2008 at 12:15 pm
You can go into the Advanced Properties of a step and set up a number of retry attempts and a retry interval. That ought to do what you need.
"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
May 23, 2008 at 12:45 pm
Thank you!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply