SQLTeam.com | Weblogs | Forums

SQL Job Email Settings



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?




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