Post reply

Alternative to SQL Mail

  • August 2, 2004 at 10:56 am

    #83458

    Hi

    I have finally given up with SQL mail, due to the fact I do not trust it. I have managed to get it to work intermitently on 3 out of 10 servers.

    Can anyone suggest an application that will monitor all my scheduled jobs and then fire off an e-mail when one fails? Also, I would like an app with a GUI interface, so I can view the current state of my servers from one central point.

    I was impressed with Spotlight, however it does not have the capability of e-mailing me, when a scheduled job fails. Plus, it was eating up the office 2 meg line, when connecting to our servers off-site!

    Any suggestions would be much appreciated.

    Cheers

  • August 2, 2004 at 11:27 am

    #517311

    A good time back I ran into an free application developed by Denis Ducasse which can be used to send e-mails via SMTP (SQL 7/2000).  The application is easy to install (and remove).  I have successfully used his application without problem in an environment which supported multiple Sql Servers.

    Denis says:

      This code can be freely modified and distributed. If you

      improve it (and there's room to improve !), please send it to me.

    If you are interested, let me know and I will send you a document describing how to use and implement along with it's DLL.

     

    Gary Andrews

    garywandrews@cox.net

     

     

  • August 2, 2004 at 11:49 am

    #517319

    XPSMTP

    Use the on step failure/success options to direct to do different paths on the jobs steps. In case of failure fire off an SMTP email.

    K. Brian Kelley
    @kbriankelley

  • August 2, 2004 at 12:59 pm

    #517327

    I did exactly what Brian suggested with great success!!!

    Thanks Brian for pointing out this helpful aid.

    Gary Andrews

     

     

  • August 2, 2004 at 8:16 pm

    #517358

    It appears there is an alternative of which I was not aware called: 

    XPSMTP.DLL - SQL Server SMTP Mail XP

     

    Please visit following website for information on this product.

     

    http://www.sqldev.net/xp/xpsmtp.htm

     

    I believe this was the application Brian was referring to in his reply and not the application I mentioned.

     

    However, Brian's reply works for both applications.

     

    Gary Andrews

     

  • August 2, 2004 at 9:53 pm

    #517360

    There is blat, was this what you were using? The advantage of xpsmtp is you can make a call from within a T-SQL batch without resorting to xp_cmdshell. So it has uses as a closer replacement to xp mail extended stored procedures.

    K. Brian Kelley
    @kbriankelley

  • August 3, 2004 at 8:24 am

    #517456

    I use rkmail.  All I have to do is register the dll, add a couple store procs and my alert e-mails are ready to go.  I manage over 50 servers many of which are 7.  I wanted a solution for both rather than having to think about two. 

    Whatever works though.

  • August 4, 2004 at 6:41 am

    #517609

    Just create a little wrapper around the below and you are cool. Works on any late-model Windows OS.

     

    '----------------                                                                                         

    Set objMessage = CreateObject("CDO.Message")                                                             

    objMessage.Subject = "Status file"                                  

    objMessage.TextBody = "See the below"                                   

    objMessage.AddAttachment"c\pre.log"                                                                       

    objMessage.Sender = "x@x.com"                                                          

    objMessage.From = "x@x.com"                                                            

    objMessage.To = "zz@zz.com"                                                             

           

    objMessage.Configuration.Fields.Item _                                                                    

    ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2                                          

    objMessage.Configuration.Fields.Item _                                                                    

    ("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.x.com"               

    objMessage.Configuration.Fields.Item _                                                                    

    ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25                                   

    objMessage.Configuration.Fields.Update                                                                   

    objMessage.Send                                                                                                                                                                                                                                                        

    '----------------


    JAW

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

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