Alternative to SQLMail

Question

Alternative to SQLMail

Jimmy Jen

SSCrazy

Points: 2915
More actions
March 4, 2005 at 2:44 pm

#87669

We use Novell network and Novell's email called Groupwise. Unfortunately, SQLMail is incompatible with Novell. I've tried successfully using CDOSYS objects to send email via SMTP and have implemented this to all the jobs so that when a job fails it will send an email to me. The problem with this is that the SMTP server sits in our parent company. When their SMTP server stops working, I don't get any more email.
Of course, one way is to buy our own SMTP server. But before I heads out this direction, are there any other alternatives ? Please help.
Thanks...Jimmy

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

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

sellertools Old Hand Points: 365 More actions · Answer 1

try looking into xp_smtp_sendmail (google it, it is an extended stored proc). Then write a wrapper proc that sends to more than one email server (which can be specified in the calling of xp_smtp_sendmail)

Andrew Greene SSC-Addicted Points: 457 More actions · Answer 2

Jimmy,

I cannot comment on your reliance on your parent company. That seems like it is a decision based on the availability and reliability of their system. But you can setup SQLMail to work with Groupwise if you decide to use their server.

I also have a Novell Network and Groupwise that I am using for SQLMail. I installed Outlook 2000 on my SQL server and set up Groupwise to allow POP3 connections from the SQL Server. (I used Outlook 2000 because it does not require the server to be logged into and the Outlook client to be running like Outlook 2002 does.) Then setup a profile on the server and go into SQLMail and select the profile. I would suggest setting up 2 separate profiles if you want to also use the email within SQL Server Agent.

I also use the CDOSYS to send email from within TSQL.

Jimmy Jen SSCrazy Points: 2915 More actions · Answer 3

Andrew,

Thank you so much for the info. I've searched Microsoft's website and all indicates Groupwise is not compatible with SQLMail. It's good to see someone (like you) have enabled SQLMail to work.

I guess the tip, if I understood correctly, is to make Groupwise to allow POP3 connections ?

For curiosity, if SQLMail works for you why do you still use CDOSYS ?

Thanks...Jimmy

Andrew Greene SSC-Addicted Points: 457 More actions · Answer 4

Jimmy,

Yeah, our Email administrator had to change the setting on the GroupWise server to allow the connection from the SQL Server machine. I recall them saying something about relaying.

I also use CDOSYS because I can use it within TSQL statements. I use this for error reporting within DTS packages and for notification of events. I don't think there is a way to use SQLMail within a DTS package or from TSQL. (Somebody let me know if I am wrong here.)

-Andrew

Jimmy Jen SSCrazy Points: 2915 More actions · Answer 5

Andrew,

You can use xp_sendmail from SQLTask within DTS. xp_sendmail is really convenient if you are using SQLMail. Take a look at BOL. It's really simple to use. If you need more detail about xp_sendmail, please let me know.

-Jimmy

Andrew Greene SSC-Addicted Points: 457 More actions · Answer 6

Jimmy,

It is coming back to me now. I set up CDOSYS prior to getting SQLMail working, so I never looked into using xp_sendmail. I have my own Stored Procedure called hpusp_sendmail that I use. I will have to try xp_sendmail now that SQLMail is working.

Thanks.

-Andrew