December 1, 2009 at 12:02 pm
We have SQL Server 2000 (SP4) running on Windows 2003 Server. I have configured maintenance jobs to send email alerts when each job finishes. These jobs have been running for years. However, I have noticed that anytime our Exchange Server or Domain Controller (using a domain account) goes down for maintenance, this causes the SQL Server Maintenance Jobs to stop sending out emails. The Maintenance Jobs continue to run successfully. This has only happened twice over the last year. I got around the issue by rebooting the SQL Server Machine. Is there any way to fix this issue? I also tried stopping/starting just the SQL Server Agent Service but that did not work. (I can not remember if I tried stopping/starting the MSSQLServer Service.)
Thanks in advance, Kevin
December 2, 2009 at 7:33 am
It's been awhile since I have done anything with SQL Agent mail, but do you have any errors in the SQL Server or SQL Agent Logs? Can you send a test email when these situations occur?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 2, 2009 at 12:32 pm
Are you saying that the maintence plan jobs fail to send jobs while Exchange servers and DC are having maintenance performed on them or after?
Joie Andrew
"Since 1982"
December 2, 2009 at 1:07 pm
Once the Exchange Server or DC come back online (after maintenance), my SQL Server Jobs continue to run successfully. The jobs just do not send out the emails associated with the jobs. There are no error messages in the SQL Error Logs, SQL Agent Logs, Windows Event Logs, JobHistory Table, etc.
The following three mail tests continue to work:
Right click SQLMail, select Properties, select Profile Name and Test Button
Right click SQL Server Agent, select Properties, select Mail Profile and Test Button
Right click Operators, select Properties, select Email Name and Test Button
Thanks, Kevin
December 2, 2009 at 1:41 pm
kevinsql7 (12/2/2009)
Once the Exchange Server or DC come back online (after maintenance), my SQL Server Jobs continue to run successfully. The jobs just do not send out the emails associated with the jobs. There are no error messages in the SQL Error Logs, SQL Agent Logs, Windows Event Logs, JobHistory Table, etc.The following three mail tests continue to work:
Right click SQLMail, select Properties, select Profile Name and Test Button
Right click SQL Server Agent, select Properties, select Mail Profile and Test Button
Right click Operators, select Properties, select Email Name and Test Button
Thanks, Kevin
I am not an expert with SQL Mail myself but would guess when it looses the connection to Exchange during your maintenance window, it does not know how to "refresh" it. Instead of restarting the services have you tried using xp_stopmail and xp_startmail procedures to restart SQL Mail client? I realize your test going through the GUI work but would believe that might be running as your username and not what SQL server is configured to use. Unless you are logging onto the server with the SQL Server credentials.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
December 2, 2009 at 2:00 pm
I may not be clear on this, but it sounds like you have maint plan jobs running during maintenance windows. If that correct? Can you modify the jobs to not run during scheduled maintenance windows? That may resolve the issue of it failing to send jobs.
Joie Andrew
"Since 1982"
December 3, 2009 at 6:20 am
No, please do not confused the isssue here or assume it is something as simple as running the SQL Server Maintenance Jobs during the Exchange/DC Servers Maintenance window. Please read my original post. The SQL Server Maintenance Jobs have been running for years. Maybe once or twice during the year, the network group would perform maintenance on the Exchange and/or DC Servers. The day after the maintenance to the Exchange and/or DC Servers, the SQL Server Jobs do not send out the email alerts. (The SQL Server Jobs continue to run successfully but just do not send out the emails.) In the past, I have resolved this by rebooting the SQL Server Machine.
Thanks for all you help, Kevin
December 3, 2009 at 7:20 am
Seems like this was a bug back in SP2, but was patched in later versions. Without knowing any error details the symptoms sound similar. It may be a matter of reapplying SP4 on the instance to get it working again.
http://support.microsoft.com/kb/833045
Joie Andrew
"Since 1982"
December 3, 2009 at 9:35 am
Your problem sounds a lot like the problem that I have had for years.
Every time that the server is rebooted, email notifications from scheduled jobs stop.
I have to stop and start the sqlserveragent service in order to get the emails notifications to work again.
I had never found a solution to this problem other than restarting the service after a reboot.
Howard
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply