January 6, 2011 at 4:57 am
Hi,
Upgrade (in place menthod) have been succeded from SQL 2000 to SQL 2008. after that i configured bckup full backup thru maintenance plan, also include in opertor for send notification whenever jobs completed.
I have received mail alert for 10 days after that mail alert not received, even backup jobs also completed at every day.
I checked database mail log, there is no error regarding database mail.
Please tell me, how to troubleshoot it ?
Thanks for your help
Ananda
January 6, 2011 at 11:37 pm
Steps I would take:
1. Test DBMail is working via send a test email. If Test email works, go to step 3
2. run following sciprt to see if SQL is/was attempting to send emial. Pay attention to the last_send_attemp_date (if any row returned)
select top 10 *
from msdb..sysmail_send_retries
where send_attempts> 1
order by last_send_attemp_date desc
if above script returns no row, run the following and correlate the last_Send_attemp_Date with the time you send test email. If found correlate entry, goto step 3. If not, try to setup a new profile with the same account info and test again.
select top 10 *
from msdb..sysmail_send_retries
order by last_send_attemp_date desc
3. Confirm with Exchange admin email did arrived on Exchange and not blocked (treated as spam or like)
January 7, 2011 at 2:07 am
Thank you John for reply...
use msdb
select top 10 *
from msdb..sysmail_send_retries
where send_attempts> 1
order by last_send_attempt_date desc
select top 10 *
from msdb..sysmail_send_retries
order by last_send_attempt_date desc
Both script no rows are comming, after sending test mail also
SMTP server IP is not ping at source SQL server box. I think if it's pinging database mail will work.
Rgds
ananda
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply