Two operators for one job

Category: sql server notification

Question

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


Hi,

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.

Replies

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)