Email notification wont work

Question

Email notification wont work

Brenda Lowe

SSC-Addicted

Points: 471
More actions
November 10, 2004 at 10:15 am

#109216

I have been trying to setup SQL Mail forever and it just won't work. Is anyone willing to help me out with this?
When I setup a notification of a job and try to send a test email from it, it gives me this error:
Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is not running; check the mail profile and/or the SQLServerAgent service startup account in the SQLServerAgent Properties dialog.
When I right click on SQL Server Agent --> Properties, I have tried to set it to an account I made of SQLAdmin. Is that what I am supposed to do? It won't accept it though. I also logged on to the server under that account, which I read I am supposed to do.
Anyway, please help me! I need it
Brenda

Viewing 15 posts - 1 through 15 (of 40 total)

You must be logged in to reply to this topic. Login to reply

Osoba SSCommitted Points: 1964 More actions · Answer 1

I'd start with this article: http://www.sqlservercentral.com/columnists/sjones/sqlmailresources.asp

and then look through some of the discussion forums on this site. very helpful info. don't forget that the mail profile needs to be set before you configure agent mail. meaning you need to be able to send and receive email via outlook before proceeding. then setup the user account for sql agent to match that mail profile.

Brenda Lowe SSC-Addicted Points: 471 More actions · Answer 2

I have gone through all of those articles. I have setup Outlook also. When is use the QA and do this:

exec master..xp_sendmail @recipients='brenda@capitaltracer.com', @subject='Mail Test'

It works, but setting up notificationss and stuff doesn't work.

Any other suggestions? Thanks!

Osoba SSCommitted Points: 1964 More actions · Answer 3

OK,

you have SQL Mail working. one of two mail options (of course not the one that works with job alerts which is what you want)

Under SQL Server Agent Properties, under the General Tab have you specified the account the service uses to run? this should match the domain account that the mail is configured for.

you should then see by the mail session/mail profile the words: MS Exchange Settings.

bare with me here...have you checked that yet?

Brenda Lowe SSC-Addicted Points: 471 More actions · Answer 4

Ok, I have done all of that now. I have set up my SQLAdmin account on both MSSQLSERVER and SQLSERVERAGENT. Also, the mail profile is setup. When I try to run a test email on a job, it won't work. It still says

Brenda Lowe SSC-Addicted Points: 471 More actions · Answer 5

So does anyone out there have any ideas about what would be going wrong?

I think it has something to do with MAPI.

Thanks!

Azzam Alkadi SSChasing Mays Points: 640 More actions · Answer 6

If you to setup an operator, can you test email by clicking test.

Azzam Alkadi SSChasing Mays Points: 640 More actions · Answer 7

Try this page, it may help you

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B315886

grant marlow SSC Enthusiast Points: 199 More actions · Answer 8

when you set up the operator and send a test message, what happens?

John Scarborough Ten Centuries Points: 1104 More actions · Answer 9

You've stopped and restarted the SQL Server?

John Scarborough
MCDBA, MCSA

Brenda Lowe SSC-Addicted Points: 471 More actions · Answer 10

Yes, I have stopped and started MSSQLSERVER and SQLSERVERAGENT.

When I try to run a test email on an operator, it says:

Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is not running; check the mail profile and/or the SQLServerAgent service startup account in the SQLServerAgent Properties dialog.

The mail profile that is set up is SQLAdmin. What does it mean by the mail seesion?

Thanks for your help!

Brenda

grant marlow SSC Enthusiast Points: 199 More actions · Answer 11

Expand enterprise manager for the server in question. Right click on SQL Server Agent node, select Proerties. What is the profile selected for mail session?

grant marlow SSC Enthusiast Points: 199 More actions · Answer 12

Oops, missed a step. Expand management after expanding the server.

What happens when you click the test button there too?

Brenda Lowe SSC-Addicted Points: 471 More actions · Answer 13

SQLAdmin is and when I click test, it works. Why won't it work when I try to do a test email for a job?

Brenda Lowe SSC-Addicted Points: 471 More actions · Answer 14

When I just open up Properties on the SQLAdmin operator, it won't let me send an email. It is still saying the same thing. I have been reading different things and just can't figure it out. Anyone out there willing to help me out some more? Thanks!

Brenda