Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Basit's SQL Server Tips

Basit Farooq is a Lead Database Administrator, Trainer and Technical Author. He has more than a decade of IT experience in development, technical training and database administration on Microsoft SQL Server platforms. Basit has authored numerous SQL Server technical articles, and developed and implemented many successful database infrastructure, data warehouse and business intelligence projects. He holds a master's degree in computer science from London Metropolitan University, and industry standard certifications from Microsoft, Sun, Cisco, Brainbench, Prosoft and APM, including MCITP Database Administrator 2008, MCITP Database Administrator 2005, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.

SQL Agent Alert System Error: [264] An attempt was made to send an email when no email session has been established

Today, I received an email from the development team complaining why they have not received any of the SQL Agent job notification emails today. Upon checking the SQL Agent error log, I see the following error message:

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

SQLAgent_ErrorLog

To investigate the issue, I followed the steps below to verify that SQL Server Agent Alert System is configured correctly and is associated with the correct Database Mail profile:

  • Right Click on SQL Server Agent, Select properties.
  • Select Alert System.
  • Select Enable mail profile.
  • Select OK.

I also successfully sent a test email using this Database Mail profile.

Although, I verified above settings and sent test emails using Database Mail, SQL Server Agent Job was still unable to notify the SQL Server Agent Operator. At this point, I decided to Google this error message because I was not sure why this error is occurring. After digging around online, I realized I just need to restart the SQL Server Agent service. After I restarted SQL Server Agent service, SQL Server Agent job notifications started working again.


Comments

Leave a comment on the original post [basitaalishan.com, opens in a new window]

Loading comments...