Wednesday, August 08, 2012

[264] An attempt was made to send an email when no email session has been established

You need to enable mail profile located in the properties of the SQL Agent,
Alert System and choose Mail System and Mail profile from the drop down listbox.
Finally you must restart the SQL Server Agent and run your scheduled job to get email notification