I have very little background using SQL. We had a personnel shift and the "Operator Notify" address used for receipt of a daily Maintenance Plan report is no longer correct. I wanted to change it.
I drilled down into the "MaintenancePlan" and see the step called "Notify Operator Task". It says "Notify Operator on Local Server Connection". The properties on the right side show an item called "OperatorNotify". The value of the field says it is a "Collection". When I open the Collection (...) I can see the name of the previous user. But it doesn't allow me to change it. When I click on "Add" the only thing it adds is an item called "System.Object". I also cannot modify that item.
In the SQL Server Agent section I found a group called "Operators". The existing name and email address were there. I added a couple of other operators thinking they would then show up as choices in the "Add Member" dialog of the Collection Editor. But they do not.
I even tried changing the name of the existing operator; but it had no affect on what displays in the "Notify Operator" task. The name in that section did not change. I could not find a "Refresh" menu item if something like that is required.
Can you point me in the right direction? Where would I define the Operators to be visible in the Add Member dialog in the Object Collection Editor?