I configured database mail server in SQL Server 2008 R2.

Posted by Yrajudba under Sql Server on 7/6/2011 | Points: 10 | Views : 1339 | Status : [Member] | Replies : 2
Hi,
I configured database mail server in SQL Server 2008 R2.
I am able to send the test mail. But when i configured this mail server to send a mail after the successful completion of the job. I am not able to receive any mail, though the job runs succesfully.
Please provide a solution
thanks in advance

Regards,
Raju




Responses

Posted by: PandianS on: 7/6/2011 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi

Kindly check the followings...

I hope you have already configured an Operator for the DB Mail...

1. Right click on JOB(you have scheduled)
2. Click Notifications on left side
3. Select the Checkbox "E-mail" and Choose the Operator(what you have configured for DB mail) and Select "When the JOb succeeds"
4. Click OK

Cheers

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Yrajudba, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Yrajudba on: 7/6/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

I did the same navigation, what you told before itself. but i dont know, still it is not working

Yrajudba, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response