unable to check logging for a database maintenance job
I am unable to check logging for a database maintenance plan.I’m running SQL Server 9.0.1399.I logged into the computer which hosts SQL then brought up Microsoft SQL Server Management Studio and logged into the instance as sa.I clicked on “Maintenance Plans” and then “Modify” for the plan under interest.As soon as I click on “Logging…” a dialogue window pops up and states:Microsoft .NET Framework / Unhandled exception has occurred in a component in your application. / Failed to retrieve data for this request. / EXECUTE permission denied on object 'sp_help_operator', database 'msdb', schema 'dbo'.That error does not make much sense because msdb is owned by sa and I logged in as sa.Further, using the new query window, sa can indeed execute sp_help_operator.

