Solved

msdb.dbo.sp_send_dbmail  is not working

Posted on 2010-11-16
6
1,443 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help with SQL Server Polygon 2 32
SQL Help 27 41
Whats wrong in this query - Select * from tableA,tableA 11 28
performance query 4 19
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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…

785 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