SQLTeam.com | Weblogs | Forums

SQL Job Email Settings


#1

Hi,

I'm not sure if this belongs here, but I'll give it a try. I have job that was created by the our previous DBA. The job sends an email to a group. The DBA does not work here anymore so I need to change the notification email to someone other than his. I added a new user to the operators and also within the Email Wizard. How do I assign this new user to the job so the email recipients see that it's from the new user and not the former employee?


#2

https://msdn.microsoft.com/en-us/library/ms190038.aspx


#3

EXEC msdb.dbo.sp_update_job @job_name = 'that_job_name',
@notify_email_operator_name = 'new_email@whatever.com'