Two operators for one job

Category: sql server notification


dktoa on Fri, 01 Feb 2019 13:53:51


I have a SQL Server Agent job.

If the job fails one email address must get a notifications. Not problem with that. But, another email address must get a notification no matter how the job ends (succeeds, fails, completes)

How to configure two operators ?

Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.


Olaf Helper on Fri, 01 Feb 2019 14:06:37

Add a T-SQL Job (on goto on error) step where you send an email with sp_send_dbmail (Transact-SQL)