SQL Server 2008 Database mail issue

Last Post 10 Feb 2011 08:45 AM by rm. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Markus_SQL
New Member
New Member

--
09 Feb 2011 10:21 AM
Environment: Win2008\SQL 2008 SP2  Test server.

I have setup Database Mail, enabled it, and can do a test email and it sends the test email just fine.  I created an Operator and then go into a job and go to the Notifications tab and select the correct operator to send.  The job runs and the email is never sent. When I run the SP_HELP_OPERATOR it never shows any attempt to send the email.  I look in the Database Mail errorlog and nothing shows up.

Is there anything I am missing?
rm
New Member
New Member

--
09 Feb 2011 12:47 PM
Have to specify db mail profile in sql agent properties -> alter system and restart sql agent.
Markus_SQL
New Member
New Member

--
10 Feb 2011 05:17 AM
I did find  that in SQL Agent and added it but it still would not work.  I just saw your post and restarted SQLAgent and it all works... wow.... Sometimes it is the simple things.  Thanks a million!
rm
New Member
New Member

--
10 Feb 2011 08:45 AM
Happy SQLing.
You are not authorized to post a reply.

Acceptable Use Policy