Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vietcave
Starting Member
11 Posts |
 Posted - 2005-05-31 : 03:26:20
|
| Hi everyone.Can I create a job that checks the status of Distribution Agent in Transactional replication and starts it if it stop?Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-31 : 15:14:38
|
| Why not just modify the existing replication jobs to retry if it fails?Tara |
 |
|
|
vietcave
Starting Member
11 Posts |
Posted - 2005-05-31 : 20:58:08
|
| That's a good idea. But it seem to have a problem.This job has 3 steps. If successful, it will quit in step 2. So I will modify step 3 and add one more step. Step 4 will return step 1. Is that OK?Thanks. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-05-31 : 22:14:59
|
| this is dangerous, what if it never goes up for some critical reason like network being down or connection problem between publisher and subscriber? worst case scenario, it will retry infinitely...another case, it was turned off intentionally, in this case, the job will not retrymodify the existing alert for replication failure and check if the job was stopped by a failure/error or intentional, create a separate job for starting the agent--------------------keeping it simple... |
|
|
|
|
|
|
How can I create a job for replication?