Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2014

    Unanswered: Email notification for SQL Agent Job that completed successfully

    I already have this SQL Agent Job set up to email a certain distribution group when the job fails

    However 2 people at my company want to receive emails when the job succeeds. Since the email option is already checked for emailing another group, is there a way to set up a 2nd email notification for this job?
    Click image for larger version. 

Name:	UpdateMrpForecast notifications.jpg 
Views:	2 
Size:	65.5 KB 
ID:	15885

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    This is a bit hokey, but you can create a second SQL Agent Operator that contains only the email addresses for the users who want to know when the job succeeds. Set the Job Notifications to "page" the new Operator on success, which will email the users when the job succeeds.

    As an alternative, make the "success" step in the job use msdb.dbo.sp_send_dbmail to explicitly send the "success" message.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts