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 |
|
mchohan
Starting Member
39 Posts |
 Posted - 2009-05-26 : 12:37:21
|
| Hi,I've got transactional replication between 2 different servers.Is there a way to send out an email if the replication fails?thanks. |
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2009-05-26 : 13:19:12
|
| When we setup replication it creates bunch of sql jobs. Try setting up email notification with in the job for failure. |
 |
|
|
mchohan
Starting Member
39 Posts |
Posted - 2009-06-01 : 07:02:03
|
| Been looking at the jobs created, not sure which is the best job to assign an email to if it fails... any tips?thanks. |
|
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2009-06-01 : 11:20:43
|
| Try sorting all jobs by category and get familiar with job catetgories . If you look at all replication jobs you will understand how they are created. |
|
|
|
|
|
|
Replication emails