Configure SQL Server with Lotus Notes

Question

Configure SQL Server with Lotus Notes

Mark Povah

Grasshopper

Points: 11
More actions
March 21, 2005 at 7:56 am

#88531

I'm new to SQL server 2000 database and would like to know if and how to configure SQL Server Agent with Lotus Notes to send email when a schedule job fails.

To be more specific when in Enterprise Manager then right click the SQL Server Agent under General Properies, how do I get my Lotus Notes as a mail profile.

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

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

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 1

Mark,

I think this thing needs Exchange Server on the network. I was not able to do it so far, we moved to Notes from Outlook 3 years ago. Instead I am using VB scripts that send SMTP emails. Write a script or let me know if you need one. Save it with vbs extension. In the job create a step that is CmdExec type and call the script as

cscript myemailscript.vbs

Please, let me know if you find something like third-party products that allow to configure SQL Mail with Notes.

Yelena

Regards,Yelena Varsha

philcart SSC-Forever Points: 47795 More actions · Answer 2

Use xp_smtp_sendmail from http://www.sqldev.net

No need for VBScript writing.

--------------------
Colt 45 - the original point and click interface

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 3

Phill,

Did you mean a link SMTP Task from the main page of your reference or did you mean to follow XP link and download XPSMTP.DLL ? Looks like useful thing.

About VBscript: we have the sub ready for a number of different scripting projects, so it was easy for us to copy and paste. Especially since we mostly need to send emails to admins (us) to notify us of something then the addresses are already there.

Yelena

Regards,Yelena Varsha

philcart SSC-Forever Points: 47795 More actions · Answer 4

Yelena

Yes the direct url is http://www.sqldev.net/xp/xpsmtp.htm

We use it on all our SQL Servers for all emails that originate from SQL Server. Since setting it up we haven't had any email problems at all.

--------------------
Colt 45 - the original point and click interface

Paul Wallington-263603 Newbie Points: 6 More actions · Answer 5

Hello guys,

I am trying to xp_smtp_sendmail to send a message to a lotus notes inbox, the email is sent fine, however the message body is is put into a .dat file attachment !!

Obviously I need the message to embed in the email so has anyone got any ideas ?

Cheers

Paul

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 6

Paul,

did you specify in parameters

@message = 'my message string goes here'

Regards,Yelena Varsha

Paul Wallington-263603 Newbie Points: 6 More actions · Answer 7

Hi Yelena,

Thanks for your reply. Have actually come up with a solution, I used html to create the message body:-

select @vMessageBody =

'<html>

<body>

' + @vName + ' has requested a Call Back.' + '

Name: ' + @vName + '

Job Title: ' + @vJobTitle + '

Telephone: ' + @vTelephone + '

Email: mailto:' + @vEmail + '

Comment: ' + @vComment + '

</body>

</html> '

exec @iStatus = master.dbo.xp_smtp_sendmail

@message = @vMessageBody,

@type = N'text/html'

This works really well

Cheers

Paul