Wednesday, August 24, 2016

Unable to send notifications for Multi-server jobs to custom Operator

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.

No comments :

Post a Comment