<div>
<div class="content wysiwyg-content">
I set up an notification for a job that I have running in SQL SERVER 2005. &nbsp;I know that the database mail is set up properly because I had it send a test email to my email addresss and it worked fine. &nbsp;But, for some reason I keep getting this error message every night when the job finishes.<br />
<br />
[264] An attempt was made to send an email when no email session has been established<br />
<br />
Can anyone tell me what I am doing wrong? &nbsp;Thanks<br />
<br />

</div>
</div>


I set up an notification for a job that I have running in SQL SERVER 2005.  I know that the database mail is set up properly because I had it send a test email to my email addresss and it worked fine.  But, for some reason I keep getting this error message every night when the job finishes.

[264] An attempt was made to send an email when no email session has been established

Can anyone tell me what I am doing wrong?  Thanks



SQL SERVER 2005 job notification

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.