My Notification alert stop working.
i didn't change anything.
when i send send test email i can see error in the event viwer:
Event Type: Error
Event Source: DatabaseMail
Event Category: None
Event ID: 0
Time: 7:07:47 AM
Database Engine Instance=DW1;Mail PID=7080;Error Message:
The update to the database failed. Reason:
The EXECUTE permission was denied on the object 'sysmail_logmailevent_sp', database 'msdb', schema 'dbo'.