Have you created a Proper Database Mail Profile?

Have you checked, the email address that you have specified in the code is an appropriate one?

With Thanks.

I am sorry, I am in India therefore you might expect some delay due to difference in Time Zone.

With Thanks,

Satnam

Can you please post the O/P which you get after executing the stored procedure?

With Thanks,

Satnam

OK.

Kindly post your email sending script. I will have a look into it and help you regarding the same.

With Thanks,

Satnam

Just send a Test Email through the Database Mail Profile which you have created and see if the test email lands in your MailBox.

Please let me know the O/P.

With Thanks,

Satnam

In fact I would advice you that if you are testing this on your test environment then disable either the Backup, Copy or Restore Job, then wait for 20 minutes,...

You shall receive the email only if the LogShipping Backup, Copy and Restore job is out of sync, in the code which I have submitted to you the threshold is...

You shall receive the email only if the LogShipping Backup, Copy and Restore job is out of sync, in the code which I have submitted to you the threshold is...

You will need to use the alter procedure dbo.sendlogshippingalertmessages

instead of

create procedure dbo.sendlogshippingalertmessages

Kindly try this out and do let me know the output.

With Thanks,

Satnam

create procedure dbo.sendlogshippingalertmessages

as

begin

SET NOCOUNT ON

declare @database_name varchar(100)

declare @time_since_last_backup int

declare @last_backup_file varchar(1000)

declare @time_since_last_copy int

declare @last_copied_file varchar(1000)

declare @time_since_last_restore int

declare @last_restored_file varchar(1000)

declare @server VARCHAR(100)

declare @i INT

declare @j-2 INT

declare

I have tested it thoroughly across our infrastructure and it really sends the alert emails very well.

I believe that your problem statement is different than mines.

Cheers,

Satnam

Please refer the below.

http://www.sql-server-performance.com/2012/automating-sql-server-transactional-log-shipping-alerts/

With Thanks,

Satnam

Why do you need Triggers on the Subscriber database. It can cause Violation of Primary Key constraint error message while replicating the Data and the Replication procedure can halt.

With Thanks,

Satnam

Can we have a look at the logic?

With Thanks,

Satnam

Recently when I was on a visit to the USA one of my customers mentioned the same problem. After a thorough investigation, it was noticed that the N/W through which...