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)