Need to have email alerts on processes

  • netscriptions


    Points: 7


    We have a SQL server 2000 server using Windows 2000 professional edition. We need email notification for our dbas so that they can monitor our SB processes. But, we use lotus notes on a domino server and operations does not let us install any email clients on the Db server. Can anyone help us understand how we could make this work?



  • AJ Ahrens


    Points: 20676

    Try using the Search on the toolbar, type Domino, select all three options and search.  Several articles on what you are looking for

    Good Hunting!

    AJ Ahrens

  • Dan Guzu


    Points: 3

    The best tool that I found for this sort of things (regardless of what mail system you use, be it Notes, Groupwise or Exchange) is a small utility called Blat.




  • aureolin

    Hall of Fame

    Points: 3520

    We're in exactly the same boat. We're a Lotus Notes shop, and I'm not allowed to install windows email clients on our server. To get around this, we use a little vbs script that sends an email directly. This does need a SMTP server. In our case, I'm referencing our Notes server.

    Obviously you'll need to fill in a few things for your situation. What's nice about this is that it can be completely customized to your situation. I use this as an error notice and confirmation step in DTS scripts and SQL jobs. Drop this script into a file called 'mail.vbs' and have fun!

    Steve G.


    'arguments are email subject, email body and email destinations, each in double

    'quotes, like

    'EXEC xp_cmdshell 'c:\vbs\mail.vbs "subject" "body" "" '

    'get the arguments

    set objArgs = Wscript.Arguments


    'WScript.Echo "To: " + objArgs(2)

    'WScript.Echo "Text: " + objArgs(1)

    'WScript.Echo "Subject: " + objArgs(0)

    'create mail message object

    Set objEmail = CreateObject("CDO.Message")

    'set from and to addresses - from address indicates which machine

    objEmail.From = "your_SQLServer_machine_here@your_domain_here"

    objEmail.To = objArgs(2)

    'Set the subject and body of the message to tell us what happened

    objEmail.Subject = objArgs(0)

    objEmail.Textbody = objArgs(1)

    'Create configuration object

    Set objConfig = CreateObject("CDO.configuration")

    Set objFields = objConfig.Fields

    With objFields

    .Item("")= 2

    .Item("")= "your_mail_server_here"

    .Item("")= 25

    .Item("")= 10


    End With

    'Set configuration object

    objEmail.Configuration = objConfig

    'Send the message


    'Clean up

    set objArgs = nothing

    set objEmail = nothing

  • mhempenstall

    SSC Veteran

    Points: 276

    We had had this issue with some of our customers.  Official Microsoft response is:


    "Microsoft does not support using SQL Mail to communicate with mail servers such as Lotus Notes, Lotus cc:Mail, or Novell GroupWise unless they are treated as POP3 servers."


  • SueB


    Points: 1537


    I got your script to work but could not get it to work with the echo statements.  I guess a message box was waiting for a response but I could not see the message box to respond so it would hang.  I was running it from query analyzer.





  • aureolin

    Hall of Fame

    Points: 3520

    SueB - you're absolutely right. The "ECHO" statements start a hidden CMD process, waiting on your response. I.e. it hangs up if you uncomment out the "Echo" statements and run this from QA. To test the script, run it from a DOS window as

    c:\vbs\mail.vbs "subject" "body" ""

    Sorry 'bout the misdirection!

    Steve G.

  • SueB


    Points: 1537

    Thanks aureolin!  That did the trick.



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

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