"sharad" <niitmalad@yahoo.co.in> wrote in message
news:d0b701c409eb$0ebb7fb0$a101280a@phx.gbl...
> Dear Friends
>
> I am working on Merge Push replication and the same is
> based on VPN connection. when the VPN connection is down
> the replication do not find the subscriber and the same
> is failed now when the VPN is connected i have to
> activate the replication manually i want that the
> replication should try every 15 min for 36 hours. One of
> SQL Guru have given me the following code to create the
> procudeure which will send me a mail after 4 hours that
> the replication is down. but it is giving an error as
> follows:
>
> "Server: Msg 170, Level 15, State 1, Procedure
> spuLogMergeFailures, Line 9
> Line 9: Incorrect syntax near 'xp_sendmail'."
> ***************************************
> create procedure spuLogMergeFailures
> as
> begin
> declare @count tinyint
> set @count = (select iCountLog from
> tLogMergeFailures)
> if @count = 3
> begin
> update tLogMergeFailures set iCountLog =
> 4,
> xp_sendmail @recipients
> = 'shailesh@geminicorp.be',
> @message = 'Replication Failed for BPO',
> @subject = 'Replication Failed'
> return
> end
> update tLogMergeFailures set iCountLog =
> iCountLog + 1
> end
> go
>
> ****************
>
> Please suggest.
>
> Best regards
> Sharad