March 23, 2006 at 8:53 am
Running SQL 2000 Replication. Need to setup ALERTS. I'm using the SQL 2005 client from my desktop. I've assembled the following instructions:
Setup Replication Alerts Setup (SQL 2005)
a) from Publisher, Launch Replication Monitor
b) right mouse click Server Name (eg. PPNTD128)
c) select 'Configure Replication Alerts'
d) select desired 'Replication Alert' (eg. Replication Agent Shutdown, Replication Agent Failure, etc.)
e) select 'Configure'
f_ select a 'Page' to configure:
-General
-Response ~ Notify Operators: DBAdmins, Production Support, Vanesa WITH E-mail, Pager, Net Send
-Options ~ Include alert error in text in: E-mail, Pager, Net Send (add additional msg if needed)
-History
We do not have SQL Mail installed on our servers. We use ActiveX scripts & ActiveBatch to initiate eMail / notifications.
Is there a way to incorporate the ActiveX scripts into SQL 2005 Alert setup?
March 27, 2006 at 8:00 am
This was removed by the editor as SPAM
April 10, 2006 at 9:31 am
I've resolved this by adding an additional step to our "Log Reader Agent" jobs. After creating the usp_send_cdosysmail stored proc in Master (<--- search the net for this one), I added a 4th step (Type: Transact-SQL script) to the jobs"
exec master..spr_send_cdosysmail
@from ='OurDistributorB@OurCompany.com',
@to ='sqladmins@OurCompany.com',
@subject ='OurDistDB Repl Failure - DBNameHere REPL-Log Reader Agent',
@body ='<B>OurDistDB Replication Failure: </B><BR> ATTRIBUTES: <Font Color=red>"DBNameHere" REPL-Log Reader Agent',
@smtpserver ='mailhost',
@bodytype ='HTMLBody'
I then modified the "On Failure Action" of the "Detect nonlogged agent shutdown" step to invoke this T-SQL to Notify the DBA's.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply