March 14, 2002 at 3:08 pm
Does anyone know of a way to automatically restart replication, either to a subscriber or the log reader, when it fails? This is in regards to SQL Server 7.0.
Jason
March 14, 2002 at 5:15 pm
You could create an alert that would run the job again. Or just have a job that checks every hour or so to start any replication job that is not running - have to be careful, sometimes you DONT want it to run!
Andy
April 3, 2002 at 3:43 am
The replication agent should be ran by a job. That job has a schedule.
Right click the Job in EM and choose properties. Click the schedule tab and set the job schedule.
I hope that helps.
Good luck
April 3, 2002 at 7:02 am
Also the job generally has a retry number and retry interval by default they are 10 and 1 minute. This can be found in the job on the steps tab. The "run agent" task and the advanced tab on it's properties. If it fails to restart itself there may be some other problem.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply