SQL 2005 SP3
I've enable database mail via SAC. In SSMS I've set up an operator with my e-mail address. I created a test maintenance plan that consists solely of a Notify Operator task just to send a test message. The plan fails with the following log:
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.4035
Report was generated on "XXXXX".
Maintenance Plan: TEstPlan
Status: Warning: One or more tasks failed..
Notify Operator Task (XXXXX)
Notify Operator on Local server connection
Task start: 2009-07-22T16:17:07.
Task end: 2009-07-22T16:17:08.
Failed:(-1073548784) Executing the query "EXECUTE msdb.dbo.sp_notify_operator @name=N'SysAdmin',@body=N'Test plan executed'
" failed with the following error: "Cannot insert the value NULL into column 'permission path', table '@temp'; column does not allow nulls. INSERT fails.
No global profile is configured. Specify a profile name in the @profile_name parameter.
The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
What am I missing?
It's never too early to begin preparing for International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me