SQL Mail and Replication

Question

SQL Mail and Replication

Cláudia Sousa Rego

SSCommitted

Points: 1780
More actions
October 11, 2005 at 9:36 am

#110218

Hello guys!!
I'm using MSDE as Publisher/Distributor and SQL Server 2000 as Subscriber.
Now i want to configure SQL Mail to send me an email when replication fails!!
HOw can i do this?
This is done in the Publisher or in the Subscriber? ( MSDE does not support SQL Mail!!!)

Thanks,
Cláudia
Regards,
Cláudia Rego
www.footballbesttips.com

Viewing 14 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

homebrew01 SSC Guru Points: 55553 More actions · Answer 1

Is it a pull subscription running at the subscriber ? I just modify the SQL agent job on the subscriber to use email notification when the job fails

Cláudia Sousa Rego SSCommitted Points: 1780 More actions · Answer 2

No.

It's a push subscription!

Cláudia

Regards,

Cláudia Rego

www.footballbesttips.com

Cláudia Sousa Rego SSCommitted Points: 1780 More actions · Answer 3

How can i configure the SQL agent job on the subscriber to use email notification when the job fails???

Any article/tutorial about this??

Thankx

Cláudia

Regards,

Cláudia Rego

www.footballbesttips.com

homebrew01 SSC Guru Points: 55553 More actions · Answer 4

Perhaps you can put a second step into your push subscription job. If the replication at step one fails, then your new step 2 won't happen. Step 2 writes a completion record to your subscriber. Your subscriber looks for it, and sends an email if it's not there.

I didn't think this out much ..... but you get the idea.

Cláudia Sousa Rego SSCommitted Points: 1780 More actions · Answer 5

Ok.

I got the ideia.

But i use wizards to configure the replication...

HowTO implement this ideia??

Thankz

Claudia

Regards,

Cláudia Rego

www.footballbesttips.com

homebrew01 SSC Guru Points: 55553 More actions · Answer 6

After you're finished configuring replication, SQL will create a regular SQL Agent job. You can then edit that job just like any other job to add an additional step.

A simpler solution might be to make a pull subscription instead of a push subscription. Then the job will run at your subscriber, which does have email, right ? If so, you can just use regular SQL notification to alert you if the job fails.

Cláudia Sousa Rego SSCommitted Points: 1780 More actions · Answer 7

Ok!

I will try!

Thanks,

Cláudia

PS- Can you see my other post??

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=227972

Regards,

Cláudia Rego

www.footballbesttips.com

homebrew01 SSC Guru Points: 55553 More actions · Answer 8

I saw it already, but didn't have any ideas about it.

Cláudia Sousa Rego SSCommitted Points: 1780 More actions · Answer 9

Thanks anyway.

Cláudia

Regards,

Cláudia Rego

www.footballbesttips.com

Cláudia Sousa Rego SSCommitted Points: 1780 More actions · Answer 10

homebrew01 said:

A simpler solution might be to make a pull subscription instead of a push subscription. Then the job will run at your subscriber, which does have email, right ? If so, you can just use regular SQL notification to alert you if the job fails.

I tried a pull subscription but when I look at publications from registered servers i can't find any.

The publication i have made has enabled anonymous pull subscriptions.

Also i'm using the same login for both servers (sa + password) and this login is part of the PAL.

What is it wrong?

Thankx,

Cláudia

Regards,

Cláudia Rego

www.footballbesttips.com

homebrew01 SSC Guru Points: 55553 More actions · Answer 11

Hmmmm that's odd ...... Do you see the server, but not the publications ?? Or do you not even see the server ? Are they on the same domain ?

Cláudia Sousa Rego SSCommitted Points: 1780 More actions · Answer 12

I can see the server.

I cann't see the publication!!!

They aren't in the same domain.

Cláudia

Regards,

Cláudia Rego

www.footballbesttips.com

homebrew01 SSC Guru Points: 55553 More actions · Answer 13

Have you read this ?

http://support.microsoft.com/default.aspx?scid=kb;en-us;321822

I had a problem a while back caused by the publisher being registered with the local name, not the actual server name.

When setting up a subscriber on the Subscriber, log on the the server itself, and make sure the Publisher is referred to as the actual server name in Enterprise Manager, not a local "nickname". Modify the host file or DNS if this is not the case.

I hope I'm not leading you too far astray .....