Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abhinav19
Starting Member
7 Posts |
 Posted - 2005-07-28 : 00:51:15
|
| Hi AllI am new to SQL ServerI am trying to refresh cubes through DTS. Now I need to send mails on successful completion of cube refresh or failure of refresh.How can I do this. We are using Lotus Notes as our mail client.How can I use the xp_sendmail function in this regard?What do i need to install on my system to get the desired?RegardsAbhinav |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-28 : 01:05:25
|
| Not sure about Notes, but for Exchange all you need to do is have the SQL Server account (the one that runs the service) to have access to a mail profile. But if you can't get this running with Notes (although it should be possible), you can go the CDO route. There is an article on the site somewhere that essentially replaces xp_sendmail with a call to the CDO mail objects. But you should probably find out what Notes will support.HTH,Tim |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-07-28 : 02:42:35
|
| You should check out Gert's DTS SMTP Mail Task at http://sqldev.net/dts/SMTPTask.htm. This gets around the limitations of having to have outlook installed. If notes supports SMTP then this method should definitely work.-ec |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-07-28 : 06:42:19
|
Lotus is not supported by sqlmail  but good news, you can find smtp solutions in the net and on this site quote:
Originally posted by abhinav19
Hi AllI am new to SQL ServerI am trying to refresh cubes through DTS. Now I need to send mails on successful completion of cube refresh or failure of refresh.How can I do this. We are using Lotus Notes as our mail client.How can I use the xp_sendmail function in this regard?What do i need to install on my system to get the desired?RegardsAbhinav
--------------------keeping it simple... |
|
|
|
|
|
|
Sending Mail Through DTS