Question about configuring SQL Mail with POP3 account

We want our SQL Server to send email messages when job fails. We do not
use Microsoft Exchange, we instead use Lotus Notes.
I read that if we install Outlook 2002 on the machine with SQL Server
and setup a POP3 account, the only way for it to send message is to have
Outlook 2002 left open or else it will just sit in the outbox.
We don't want to have to leave outlook 2002 open so what are other
alternatives?
If we put on Outlook 2000, will that need to be left open? Any other
soultions available to us?
Would it do anything to help if we put Lotus Notes on the machine and
set it up somehow with that?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Another alternative is to just use smtp (no mapi) to send
email. You can find an xp to do this at:
http://www.sqldev.net/xp/xpsmtp.htm
You can just add a step that sends the mail as an On Failure
step in your job.
-Sue
On Mon, 06 Oct 2003 13:37:59 -0700, Colin Colin
<ccole@.ghs.guthrie.org> wrote:
>We want our SQL Server to send email messages when job fails. We do not
>use Microsoft Exchange, we instead use Lotus Notes.
>I read that if we install Outlook 2002 on the machine with SQL Server
>and setup a POP3 account, the only way for it to send message is to have
>Outlook 2002 left open or else it will just sit in the outbox.
>We don't want to have to leave outlook 2002 open so what are other
>alternatives?
>If we put on Outlook 2000, will that need to be left open? Any other
>soultions available to us?
>Would it do anything to help if we put Lotus Notes on the machine and
>set it up somehow with that?
>
>
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!