July 19, 2011 at 4:18 pm
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2011-07-19T14:35:01). Exception Message: Cannot send mails to mail server. (A recipient must be specified.).
I can send a test e-mail using the full e-mail address but not when I use the operator.
July 19, 2011 at 4:35 pm
Have you enabled a mail profile for SQL Agent?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 19, 2011 at 4:35 pm
Do you mean that you can send mail when you test the profile but when you use SQLserver agent and operator it fails.
If this is the case, ensure sp_configure 'agent xps' are enabled.
You can also ensure your operator mail is linked to a job, once that is done
restart your agent, you don't need to restart SQL but you need to give the agent a boot.
Cheers
Jannie
July 19, 2011 at 4:39 pm
The operator is enabled.
The SQL agent mail profile is enabled.
July 19, 2011 at 4:44 pm
Jannie-186227 (7/19/2011)
Yes, everything works when I use r@msn.com but when I use the operator 'rtest' I get the error in my original post.
If this is the case, ensure sp_configure 'agent xps' are enabled.
How do I do that?
July 19, 2011 at 4:52 pm
Have you restarted the agent ?
exec sp_configure 'agent xp', 1
reconfigure
July 19, 2011 at 4:53 pm
Here is the technet article on enabling agent xps
http://technet.microsoft.com/en-us/library/ms178127.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 19, 2011 at 4:58 pm
Okay,
After going onto the server itself and restarting the SQL Server Agent (after two hours of beating up on the server) everything seems ok.
Thanks everyone!
July 19, 2011 at 5:03 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply