October 13, 2011 at 6:42 am
Hello, I an currently running the following SQL Server version:
Microsoft SQL Server 2005 - 9.00.5000.00 (X64) Dec 10 2010 10:38:40 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7600: )
I have a number of jobs that are configured to send an email on job failure to a specified email group but it is now working. I have an operator set up. How can I troubleshoot and fix this.
Database mail does work for this email group.
Thank you!
David
October 13, 2011 at 6:58 am
Hi,
Have you restart your SQL Agent after the operator set up?
Jeff.
October 13, 2011 at 7:05 am
Yes I have.
October 13, 2011 at 7:25 am
Your mail profile was enabled before the Agent restart?
Jeff.
October 13, 2011 at 7:40 am
Yes. I am seeing these entries in the SQL Server log:
10/13/2011 09:35:38,,Error,[264] An attempt was made to send an email when no email session has been established
10/13/2011 09:34:36,,Warning,[408] SQL Server MSSQLSERVER is clustered - AutoRestart has been disabled
10/13/2011 09:34:36,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
10/13/2011 09:34:36,,Warning,[260] Unable to start mail session (reason: No mail profile defined)
10/13/2011 09:34:35,,Information,[129] SQLSERVERAGENT starting under Windows NT service control
10/13/2011 09:34:35,,Error,[364] The Messenger service has not been started - NetSend notifications will not be sent
October 13, 2011 at 8:15 am
Here is the solution:
In SQL server Management Studio -> SQL Server Agent -> properties -> Alert System -> Enable mail profile. Give SQL Server Agent a restart and it works!
October 13, 2011 at 8:44 am
🙂 Cool
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply