MS SQL Server Replication - Replication Alerts

Author

Replication Alerts

A. Robinson

2005-09-26, 11:23 am

I have a question regarding Replication Alerts.

I have set up alerts to trigger in the event any of the replication agents
fail. I set this up under the Replication Alerts section of the Replication
Monitor.

I've had actual Distribution Agents fail but yet I receieved no e-mail
notification. One of the errors is Error 8144:
Procedure or function %.*ls has too many arguments specified.

This error causes the Distribution Agent to fail. When it does, there is no
e-mail notification

In order to get the e-mails, do I need to actually have those alerts
triggered by the failure of the job itself (distribution, snapshot, etc.)?
Essentially, put a step in the job after the Detect Nonlogged Shutdown that
invokes the job that sends the notification?

Any input would be appreciated!

Thanks

Hilary Cotter

2005-09-26, 8:24 pm

run this script in QA.

IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'A. Robinson
special'))
---- Delete the alert with the same name.
EXECUTE msdb.dbo.sp_delete_alert @name = N'A. Robinson special'
BEGIN
EXECUTE msdb.dbo.sp_add_alert @name = N'A. Robinson special', @message_id =
8144, @severity = 0, @enabled = 1, @delay_between_respo
nses = 60,
@include_event_descr
iption_in = 5, @category_name = N'[Uncategorized]'
END

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"A. Robinson" < ARobinson@discussion
s.microsoft.com> wrote in message
news:00F14A75-3867-45F3-8858- A7BCFF11636A@microso
ft.com...
> I have a question regarding Replication Alerts.
>
> I have set up alerts to trigger in the event any of the replication agents
> fail. I set this up under the Replication Alerts section of the
Replication
> Monitor.
>
> I've had actual Distribution Agents fail but yet I receieved no e-mail
> notification. One of the errors is Error 8144:
> Procedure or function %.*ls has too many arguments specified.
>
> This error causes the Distribution Agent to fail. When it does, there is
no
> e-mail notification
>
> In order to get the e-mails, do I need to actually have those alerts
> triggered by the failure of the job itself (distribution, snapshot, etc.)?
> Essentially, put a step in the job after the Detect Nonlogged Shutdown
that
> invokes the job that sends the notification?
>
> Any input would be appreciated!
>
> Thanks
>

Sponsored Links