Post reply

SQL Mail

  • February 9, 2007 at 8:15 am

    #62126

    I don't know if anyone else shares this feeling but I can't rely on this option anymore. I have been pinched one many times on the reliability of this. That being said, can anyone recommend a product that they use to help monitor SQL jobs and SQL errorlogs to inform me of a problem? I have to monitor about 60 servers for this.

    Thanks!

  • February 9, 2007 at 8:25 am

    #688862

    I use smtp to send emails. If you have access to a server i feel that is the best way. I kickoff a visual basic script to do it.

    Hth,

     

    Brian

    Think great, be great!

  • February 9, 2007 at 8:41 am

    #688869

    You can also use alerts and track ur error messsages and other processes in SQL Server. Mail if any alert occurs.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • February 9, 2007 at 9:09 am

    #688881

    Hi,

    I have implmented XP_SMTP_MAIL ( http://www.sqldev.net/xp/xpsmtp.htm&nbsp and created some wrapper stored procedures to call the module.

    To implement this, you need access to an SMTP server.

    Hope this helps.

     

    Pete

    Peter Gadsby
    Business Intelligence Consultant
    www.hgconsult.co.uk

Viewing 4 posts - 1 through 3 (of 3 total)

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