SQL Agent mail not sending the email

Question

Post reply

SQL Agent mail not sending the email

pinky

SSCommitted

Points: 1997
More actions
November 30, 2006 at 3:12 pm

#170510

Hi,
Can any one help me in getting this issue resolved? I am trying to send email through the SQL agent mail and i have set up the mail notification for operators. when i test it, It says that the "Message has been sent successfully" but i dont receive any mail. Can anyone tell me what exactly the problem could be. The domain account has got all the necessary permissions for sending and receiving the email.
Please help me out!!!
Thanks for the help

Viewing 5 posts - 1 through 4 (of 4 total)

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

Dinesh Asanka SSChampion Points: 11058 More actions · Answer 1

are you sure youre mail server is working fine. check badmail folder to verify

My Blog: http://dineshasanka.spaces.live.com/

pinky SSCommitted Points: 1997 More actions · Answer 2

where do i find the badmail folder? Please let me know. I spoke to the person who manages the exchange server and they went into that box and tried sending mail from that box and i got a mail from that box. it clearly says that that domain has got all the required permissions to send out the emails.

Tim Coker Right there with Babe Points: 715 More actions · Answer 3

C:\Inetpub\mailroot\Badmail or wherever you have inetpub set up for.

There are 2 places to setup mail. one is under suport services, where you select the profile. This one is used when you execute xp_sendmail (or whatever the sp is for sending mail). I'm guessing that's what your exchange person did.

The other place, and this sounds like where you're screwed up, is under sql server agent properties, under the general tab. You have to select the mail profile there, too.

pinky SSCommitted Points: 1997 More actions · Answer 4

The mail profile in sql agent properties under the general tab is selected correctly.

I saw few issues hope this helps:

I logged into that server in which i am finding issues and tried to open up outlook and it gave me an error saying that the windows installer is not properly installed.........

I went into control panel->mail->show profiles->selected the profile and clicked on properties-> email accounts

once i clicked on the email accounts it gave me the same error "windows installer is not properly installed........."

does this mean that the outlook is not properly installed on that box which is causing the problem or it doesnt matter even if the outlook doesnt open?

And in that domain account under outlook i see a .pst file, is it blocking the email from being sent from sql.

Any help is really appreciated.