The last step to run was step 1 (Subplan_1). NOTE: Failed to notify ‘Operator’ via email.
Ever get this message? I did and it took me a couple minutes to remember how to resolve it so I thought I would post about it just in case I’m not the only one LOL.
I first decided to “right click” on the Database Mail object under the management folder and selected “Send Test Email” I entered my email address and sent the email 1/2 expecting not to get it but my blackberry vibrated and the familar “Notifier_ChiGong”sounded.
So I’m getting mail directly from the Database Mail service but SQL Server Agent is not able to send… then the lightbulb went off and I remembered that you need to go to the properties of SQL Server Agent and under the Alert System page you need to enable the Mail Profile for SQL Server Agent. (don’t forget to restart SQL Server Agent for the changes to take effect)
I felt like a “newb” on that one but I’ve never been ashamed of making my forgetfulness and embarrassments public. So yeah I’ll take one for the team and if you “googled” this problem and came to this page don’t worry I wont tell anyone. LOL
Enjoy!!
