I am running SQL Server 2005 SP3 and I have a problem with receiving email notifications.
I setup a Database profile and when I send out a test email then I receive it. I then enabled the mail profile in the SQL Server Agent properties but in there the test button is greyed out.
After all of this I created an SQL JOB and configured to receive notifications if the jb fails. Well the emails are never being send out. When I check the SQL Server Agent logs then I find the errors below with time stamps when the email should be send out:
Date 4/25/2010 8:03:24 PM
Log SQL Agent (Current - 4/25/2010 8:03:00 PM)
 An attempt was made to send an email when no email session has been established
I looked here in the forum but I was not able to find any useable solution.
Can anyone help please?