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 |
|
sqlpal2007
Posting Yak Master
200 Posts |
 Posted - 2008-10-30 : 10:17:44
|
| Hello,We have multiple global sites replicating to North America site. Is there any way to identify and email to the DBAs if replication is down from any site? I wrote a job which would check and inform if replication has any error (using sysjobs). How would I find if publisher's server rebooted or someone stops the replication and forgets to restart.I would appreciate your help.Thanks,-P |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-10-30 : 11:00:09
|
| You can collect the output of msdb..sp_help_job, and check the current_execution_status column. I am not certain what happens when SQLAgent is not running, though. I would expect the jobs would all show as not running in that case, though. As with everything, test it for every case you can think of, and a couple others. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-30 : 12:12:34
|
| With the jobs you have setup, you can use notification to send email to you and output as well. You can use Replication monitor to see the status. |
|
|
|
|
|
|
Replication ON/OFF