469,573 Members | 1,075 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,573 developers. It's quick & easy.

SQLMail woes !

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!
Jul 20 '05 #1
3 3300
Maybe u should post this query to an SQL Server newsgroup! What are doin here?
Jul 20 '05 #2
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 !
Jul 20 '05 #3
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.
Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Mark | last post: by
2 posts views Thread by Andrew Thompson | last post: by
reply views Thread by Arun Bhalla | last post: by
1 post views Thread by matthewalbum | last post: by
9 posts views Thread by Mark Rae | last post: by
4 posts views Thread by =?Utf-8?B?VkIgSm9ubmll?= | last post: by
1 post views Thread by Mike Howarth | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.