I am trying to use a Trigger to execute the xp_sendmail stored procedure so a notification message will be sent after a new record is inserted. Here is the code I used to create the trigger:
CREATE TRIGGER [trgEmailGreg] ON [dbo].[tblRMR]
@recipients = 'Brick, Greg',
@message = 'A new RMR has been submitted. Please review and disposition as necessary',
@subject = 'New RMR submitted'
Every time I try to insert a record I get an error saying the xp_sendmail stored procedure cannot be found.
Why is this happening?