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 |
|
kumaresh81
Starting Member
2 Posts |
 Posted - 2005-04-28 : 04:01:49
|
| Do any one know how to detect a distribution agent failure thru program. Is there any way to start it programmatically.Any help would be great |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-05-02 : 00:58:42
|
quote:
Originally posted by kumaresh81
Do any one know how to detect a distribution agent failure thru program. Is there any way to start it programmatically.Any help would be great
a. there is an alert to identify if the agent has stopped (error 14151), b. you can also add a step on the distribution job if it failsc. you can also monitor the sysprocesses table if the job failedi prefer (a), simplest  --------------------keeping it simple... |
 |
|
|
|
|
|
Monitoring & Starting Distribution Agent thru pgm