Job Notification

• Rem70Rem

  SSCertifiable

  Points: 6166

  More actions

  October 6, 2011 at 1:56 pm

  #260120

  Hi,

  I am not able to the email notifications when a job completed.

  The Alert System feature is set in the Property of the SQLAgent.

  I have a default profile set to Yes in the manage profile security.

  I have and operator

  The notification is set for the job

  Database mail work

  msdb.dbo.sp_notify_operator works too.

  Did I missed something?

  Also I see this message in the errorlog of the SQLAgent: [264] An attempt was made to send an email when no email session has been established

  Thanks

• JeremyE

  SSCoach

  Points: 16201

  More actions

  October 6, 2011 at 3:56 pm

  #1391522

  After enabling the mail profile in SQL Agent, you need to restart SQL Agent. A restart of SQL Agent should resolve your issue.