So it turns out that you can't configure a custom operator to notify for a multi-server job (SQL 2014). not sure if this is the case on SQL 2016 yet.
This job has one or more notifications to operators other than 'MSXOperator'
BTW if you do manage to save this multiserver job it may also cause your Multiserver job to become blocked on the target server and you'll need to manually clear it out.
If you find this article useful please leave me a comment.
Wednesday, August 24, 2016
Unable to send notifications for Multi-server jobs to custom Operator
Labels:
Database Mail
,
SQL
,
SQL Operators
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment