Setting up email for Operator in SQL2000

Setting up email for Operator in SQL2000 - ERROR

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ant - 19 Mar 2008 08:08 GMT

Hi,
I'm trying to set up an Email name for an operator to be used inSQL Agent.

When I test the Email Name, I get an error:

Error 22022: SQL Server Agent Error: The SQL Server Agent Mail session is
not running: Check the mail profile and/or the SQL Server Agent Service
startup account in the SQL Server Agent Properties dialog box.

I have setup a non human account in AD called sqlmail. I can send email from
it no problem.

I have tried both using sqlmail & its pwd as the Service Startup account &
also tried using the System account. Neither of these seem to work.
I have also added sqlmail@ourdomain.com as the Mail Profile

but always get the same error.

Would anybody know what is going wrong here. I'd be most appreciative if
somebody could help out on this one.

Many thanks
Ant

Reply to this Message

Bigadds - 15 Apr 2008 15:51 GMT

hi

i am a noob but set up mail notification today. after alot of hair pulling
i found i had to go to the proprties of the server agent and select alert
system and then enable database mail. then choose database mail.

hope this helps

> Hi,
> I'm trying to set up an Email name for an operator to be used inSQL Agent.
[quoted text clipped - 19 lines]
> Many thanks
> Ant

Reply to this Message

Ant - 16 Apr 2008 08:10 GMT

Hi Bigadds,

I very much appreciate your reply.
I went to the Alert System tab but there was no 'Enable Database mail'
option.
There is only a choice of Notifying via email/pager/not send however this is
already ticked for email. Just for your information I'm using SQL2000 so
possibly we're using different versions

Many thanks

Ant

> hi
>
[quoted text clipped - 27 lines]
> > Many thanks
> > Ant

Reply to this Message