MSDE and SQL Mail.

Question

MSDE and SQL Mail.

Luke L

SSC-Dedicated

Points: 35547
More actions
January 9, 2006 at 2:18 pm

#111200

I'm having some difficulties with setting up my MSDE(2000 SP4) server to be able to send me mail. I've already installed outlook(2003) and setup the profile correctly to work with our Exchange(2003) server. I was able to send myself a mail while logged in via the SQLServer Agent Account by creating a DTS job and executing it. When I ran XP_sendmail I received a DLL error, so I know I have that to work through, but I Was figuring since I was able to send mail via a DTS job... I am not able to do the same with my own account. I'm an Enterprise/Exchange/SQL admin, so I should have rights to that mailbox.
I found some documentation stating that SQLMail should be listed with the DTC in the support services section, and that I should be able to configure these options there. The only problem is that I don't see SQL Mail listed there.
I'm really only looking to get success or failure (w/ the failure reason) mails for my DTS jobs that are running. I just don't want to have to log in as the SQL Server Agent whenever I want to create a job that mails me at the end of it.
Thanks in advance for your help.
Luke.
To help us help you read this[/url]For better help with performance problems please read this[/url]

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

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

philcart SSC-Forever Points: 47796 More actions · Answer 1

If all you want is success or failure messages from DTS, then take a look at the DTSSMTP Mail Task over at http://www.sqldev.net

This uses basic SMTP mail settings and doesn't require any fiddling with Outlook and mail profiles.

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

Luke L SSC-Dedicated Points: 35547 More actions · Answer 2

Thanks I think that will be just the ticket.

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]

Andy sql SSCrazy Eights Points: 9496 More actions · Answer 3

I am a bit confused. In the description, it says:

"It does not require any software to be installed"

and then the next section describes how to install the DTS custom task. Am I being stupid here? What part of running an EXE does not count as installing software?

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

I think the reference to installing software is for mail servers, etc...

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

Andy sql SSCrazy Eights Points: 9496 More actions · Answer 5

Ok, I was being a pedantic.

As a follow-up question, how do you pass variables into this custom DTS? For example, I have a table with email addresses, subject, body, etc; how do I send an email to each entry in the table, using this custom task?