msdb.dbo.sp_send_dbmail is not working

Experts -

I've this DB mail setup was working fine till yesterday and stopped sending report since this morning. But, the Alert notification working fine.

The SP ran fine and the reports generated in the specified location but the email was not sent. The JOB history says its all success.

How can I troubleshoot this issue?

Thanks,

~sve
LVL 18
sventhanAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Ok, Can you check whether the Exchange server or mail server is up and running and works without any issues.
As of now, SQL Server is not able to connect to your Exchange Server and also check out for any connectivity issues between these two.

Or your Database mail configuration might have been corrupted.
Try reconfiguring Database mail again to get it work and steps to configure it here.
http://www.databasejournal.com/features/mssql/article.php/3626056/Database-Mail-in-SQL-Server-2005.htm
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Check for any errors related to Database mail by executing the below query:

select * from msdb.dbo.sysmail_event_log
0
 
sventhanAuthor Commented:
Thanks Jegan.

  description
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2010-11-16T08:01:43).
Exception Message: Cannot send mails to mail server. (The operation has timed out.). )

The notifications I set up working fine (index maintenance, update stats etc.,).
But  these are some business reports with attachment is not working. The text file was created in it looks good.

The problem is not sending it by email.

Any thoughts...
dbmailIssue.txt
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
sventhanAuthor Commented:
Awesone!

You're the man.
0
 
sventhanAuthor Commented:
I mean Awesome!
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Welcome..
0
All Courses

From novice to tech pro — start learning today.