Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 [264] An attempt was made to send an email when no

Author  Topic 

sdw
Starting Member

6 Posts

Posted - 2008-11-30 : 04:35:29
I have a problem with the SQL Server 2005 SP2.

I've configured the Database mail and it works perfectly. However, when I try to send e-mail through a job it fail.

I've tried the following solution but it didn’t fix it up:

• Check if the SQL Server Agent Database mail is enabled: Yes it is.
• Restart the SQL Server Agent: many times

All my readings directed me to restart the SQL Server Agent.


visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-30 : 06:54:48
see this
http://sqlserver-qa.net/blogs/tools/archive/2007/07/31/error-an-attempt-was-made-to-send-an-email-when-no-email-session-has-been-established.aspx
Go to Top of Page
   

- Advertisement -