Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

msdb.dbo.sp_send_dbmail  is not working

Posted on 2010-11-16
6
Medium Priority
?
1,523 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

722 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