SQL 2005 Mail

[qsac]

got a real weird one.

Setup Database Mail. Setup operator.

i can successfully send a test mail in database mail.

I can see all my alerts setup in the Operators tab, but no email being sent.

anyone ever see this before?

Steve

 

[ptheriault]

have you checked all the database logs?
are there any error messages?

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

What does the SQLMail log say?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[qsac]

Got It!!!

forget to set the mail profile in SQL Agent.

thanks to all that assisted.

Q