Post reply

SQL Mail in Replication

  • July 20, 2005 at 3:51 am

    #88115

    Hi folks!

    I never use SQL Mail and i only know that is a way to receive e-mail messages generated by Microsoft SQL Server.

    Can I configure in some way to provide the status of replication??

    Thanks

    Regards,

    Cláudia Rego

    www.footballbesttips.com

  • July 20, 2005 at 5:45 pm

    #575947

    You can configure SQL Mail to send you any type of email based on any SQL Server event.

    As for the status of Replication, just what exactly would you like emailed?

    Kindest Regards,

  • July 21, 2005 at 8:55 am

    #576108

    instead of verifying every day of morning if my replication ran ok, I want receive an email.
    In error case i want de error cause, for ex: timeout, etc
    In case everything ok, need a ok.
    Is that possible??
    Thanks
    Regards,

    Cláudia Rego

    www.footballbesttips.com

  • July 21, 2005 at 11:50 am

    #576176

    I have our replication agent jobs set up to email me if one of them fails.  You can adjust the job properties (where the job runs, distributor or subscriber) and have it email you the completion status.  Unfortunately, it doesn't give detailed information on failures, but at least you won't have to keep looking it up as long as it succeeds.

    Dylan

    Dylan Peters
    SQL Server DBA

  • July 25, 2005 at 10:38 am

    #576863

    That what I want

    HOW I configure this in Enterprise Manager?

    Thanks

    CLaudia

    Regards,

    Cláudia Rego

    www.footballbesttips.com

  • August 2, 2005 at 8:16 am

    #578849

    Does anybody help me configuring SQL Mail through EM??

    After replication is working I think it's necessary some policy on the growth of the database. If i don't worry, some day my databases will occupy all my machine.

    What is the best policy???

    i can estimate the diary growth...

    Thanks all

     

    Regards,

    Cláudia Rego

    www.footballbesttips.com

  • August 3, 2005 at 5:03 am

    #579092

    best policy is to use replication monitor group. Add all the distributors you want to monitor, and if there are any failures you can tell at a glance where they are and fix them.

    --

    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

Viewing 7 posts - 1 through 6 (of 6 total)

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