Solved

msdb.dbo.sp_send_dbmail  is not working

Posted on 2010-11-16
6
1,452 Views
Last Modified: 2013-11-05
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
0
Comment
Question by:sventhan
  • 3
  • 3
6 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 34144684
Check for any errors related to Database mail by executing the below query:

select * from msdb.dbo.sysmail_event_log
0
 
LVL 18

Author Comment

by:sventhan
ID: 34144793
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
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 34144890
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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 18

Author Closing Comment

by:sventhan
ID: 34144983
Awesone!

You're the man.
0
 
LVL 18

Author Comment

by:sventhan
ID: 34144990
I mean Awesome!
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 34145068
Welcome..
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question