Email Notification on SQL Agent Job

• david.alcock

  SSCertifiable

  Points: 6021

  More actions

  February 18, 2015 at 8:35 am

  #314689

  Hi all

  I have a SQL Agent job in test where on completion it is configured to send an email to an Operator but I am receiving SQLServerError 14607, profile name is not valid in the error log, and no email surprise surprise!

  Now database mail is working fine under scripts, I can script out using sp_notify_operator and I receive the mail but whenever I use a SQL Agent Job, no go. Profile is public and default.

  Any ideas?

  D

  'Only he who wanders finds new paths'

• david.alcock

  SSCertifiable

  Points: 6021

  More actions

  February 18, 2015 at 8:38 am

  #1778375

  Facepalm, I bet its because the mail hasnt been enabled on SQLAgent, aaaargh!

  'Only he who wanders finds new paths'