Solved

msdb.dbo.sp_send_dbmail  is not working

Posted on 2010-11-16
6
1,432 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
LVL 18

Author Closing Comment

by:sventhan
Comment Utility
Awesone!

You're the man.
0
 
LVL 18

Author Comment

by:sventhan
Comment Utility
I mean Awesome!
0
 
LVL 57

Expert Comment

by:Raja Jegan R
Comment Utility
Welcome..
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

763 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now