I configured database mail server in SQL Server 2008 R2.

Posted by Yrajudba under Sql Server on 7/6/2011 | Points: 10 | Views : 2623 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

Latest Posts