SQLMail woes !

[Angel Cat]

Trying to get my jobs to send mail when job fails. Should be easy but
it's giving me headache

Had a whole slew of issues. Outlook is installed with a n outlook
mail profile set up that can send mail in outlook. I can create a
SendMail DTS and execute it to send mail

Email works in these scenarios
1. I create a DTS package in SQL Server with just SendMail with the
same Profile "ABC" and click Execute and it sends
2. I can send using Outlook with the same profile "ABC"
3. I can run DTSRun with command prompt calliing the DTS package and
it sends fine

However it wont send in these 3 scenarios (where I need it!):

1. I go to Operator, and put my Profile "ABC" in the Email Name,
click Test and I get this error "Error 22022: SQLServerAgent Error:
The SQLSErverAgent mails ession is not running; check the mail profile
and/or the SQLServerAgent service startup account in the
SQLSErverAGent Properties
sQLServer Agent is running

2. If I add the DTS Package "EmailTest" to one of my jobs as a step
to go to if the 1st step fails, nothing gets sent

3. In JObs -- Notificatioin, If I set the E-maill operator to my
operator, nothing gets sent

I set the Mail Profile to the Mail Profile (in SQL Server AGent'
properties)
However when I click Test, I get this error:
Error 0: Cannot load the DLL sqlmap70.dll, or one of the DLLs it
references

I am using
SQLServer Version 8.00.194,
OS Windows 2003

Help!

[Achilles]

Maybe u should post this query to an SQL Server newsgroup! What are doin here?

[Ross Presser]

On 11 Nov 2004 07:04:29 -0800, Achilles wrote:

Maybe u should post this query to an SQL Server newsgroup! What are doin here?

Maybe you should look around yourself at your surroundings. Or at least at
the headers.

From: ac**************@rediffmail.com (Achilles)
Newsgroups: comp.databases.ms-sqlserver
Subject: Re: SQLMail woes !

[Ross Presser]

On 10 Nov 2004 16:01:18 -0800, Angel Cat wrote:

Trying to get my jobs to send mail when job fails. Should be easy but
it's giving me headache

Had a whole slew of issues. Outlook is installed with a n outlook
mail profile set up that can send mail in outlook. I can create a
SendMail DTS and execute it to send mail

Email works in these scenarios
1. I create a DTS package in SQL Server with just SendMail with the
same Profile "ABC" and click Execute and it sends
2. I can send using Outlook with the same profile "ABC"
3. I can run DTSRun with command prompt calliing the DTS package and
it sends fine

However it wont send in these 3 scenarios (where I need it!):

1. I go to Operator, and put my Profile "ABC" in the Email Name,
click Test and I get this error "Error 22022: SQLServerAgent Error:
The SQLSErverAgent mails ession is not running; check the mail profile
and/or the SQLServerAgent service startup account in the
SQLSErverAGent Properties
sQLServer Agent is running

2. If I add the DTS Package "EmailTest" to one of my jobs as a step
to go to if the 1st step fails, nothing gets sent

3. In JObs -- Notificatioin, If I set the E-maill operator to my
operator, nothing gets sent

I set the Mail Profile to the Mail Profile (in SQL Server AGent'
properties)
However when I click Test, I get this error:
Error 0: Cannot load the DLL sqlmap70.dll, or one of the DLLs it
references

It sounds as if possibly you have set up the Outlook profile while logged
in as yourself, instead of while logged in as the SQLAgent user.