Monday, March 12, 2012

How to configure email notify in replication...

Hi friends,
How to configure email notify in replication ?, so, sql
admin will know immediately if replication process is fail
or succed.
I already configure mail profile in sql agent, it works
properly.
I try to configure email notification in log reader agents
and distributor agent, but I got no email notification.
thanks.
Within the job you can create a TSQL step that runs xp_sendmail.
HTH,
Paul Ibison
|||use the replication alerts for this.
"kresna rudy k" <anonymous@.discussions.microsoft.com> wrote in message
news:1c48901c421fb$4bae5280$a301280a@.phx.gbl...
> Hi friends,
> How to configure email notify in replication ?, so, sql
> admin will know immediately if replication process is fail
> or succed.
> I already configure mail profile in sql agent, it works
> properly.
> I try to configure email notification in log reader agents
> and distributor agent, but I got no email notification.
>
> thanks.

No comments:

Post a Comment