SQL Job Email Settings

SQL Server Administration
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

1 Like
3

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

1 Like