December 11, 2008 at 1:08 pm
I've recently got Database Mail working. I thought I would test it and have it send me an email when a SQL Job I have ran successfully. (This job only runs once a day, so I don't mind getting a daily email for a while.) It worked great for a few days, but now all of a sudden it has stopped working. I've checked the job and its run fine each day since I set it up.
So, why does it stop sending emails?
Kindest Regards, Rod Connect with me on LinkedIn.
December 11, 2008 at 1:17 pm
check the error logs..look in Database Mail folder of the error logs. Lets see what you find..
Thanks!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 15, 2008 at 8:38 am
I've just taken a look at the logs that you mentioned. The last message I see there is one from 12/6/2008 that says, "DatabaseMail process is shutting down". But I would think that would be for a particular incidence of DatabaseMail being used to send an email, and not some process which runs DatabaseMail. Or am I wrong about that?
Kindest Regards, Rod Connect with me on LinkedIn.
December 15, 2008 at 11:25 am
Database Mail process shuts itself down after a certain period of inactivity. The default value is 10 minutes, which can be changed via Database Mail Configuration Wizard (can be found in Management Studio Object Explorer under Management | Database Mail) in "Configure System Parameters" dialog.
There are some other steps you can take to troubleshoot the issue, such as making sure your profile is set correctly. Here is a good starting point:
http://msdn2.microsoft.com/en-us/library/ms175887.aspx
or you can do this:
First set up the database mail as you did. Second you would modify the properties of the Sql Server Agent. Select "Alert System" and then check "enable email profile". Select "database mail" and the profile, then restart the SQL SERVER AGENT.
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 15, 2008 at 12:53 pm
The_SQL_DBA (12/15/2008)
Database Mail process shuts itself down after a certain period of inactivity. The default value is 10 minutes, which can be changed via Database Mail Configuration Wizard (can be found in Management Studio Object Explorer under Management | Database Mail) in "Configure System Parameters" dialog.There are some other steps you can take to troubleshoot the issue, such as making sure your profile is set correctly. Here is a good starting point:
http://msdn2.microsoft.com/en-us/library/ms175887.aspx
or you can do this:
First set up the database mail as you did. Second you would modify the properties of the Sql Server Agent. Select "Alert System" and then check "enable email profile". Select "database mail" and the profile, then restart the SQL SERVER AGENT.
Thanks!!
Thank you for your help. I've already enabled the email profile, and selected the profile for the mail profile in the Mail session section.
Kindest Regards, Rod Connect with me on LinkedIn.
December 15, 2008 at 1:02 pm
Just a quick addendum. Here's the link to the SQL Server 2005 page that is like the page you referenced for SQL 2008:
msdn.microsoft.com/en-us/library/ms175887(SQL.90).aspx
But I don't see where, on the link I've provided, it can either lengthen the time it takes before Database mail's agent times out, or cancel it entirely. I'm probably missing something or overlooked it.
Kindest Regards, Rod Connect with me on LinkedIn.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply