Thank you

//------------------------

This is example,But can't send mail.

Please check code syntax me.

CREATE TRIGGER SendMail ON OIL_Price

AFTER INSERT

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

declare @profile_name varchar(250)

declare @recipients varchar(500)

declare @body varchar(5000)

declare @subject varchar(500)

declare @price decimal(18,2)

-- Insert statements for trigger here

set @price =(SELECT top 1 OIL_PRICE FROM OIL_Price order by OIL_DATE desc)

EXEC msdb.dbo.sp_send_dbmail

set @profile_name = 'Oil Price MPV'

set @recipients = 'prasitk@mitrphol.com'

set @body = 'Just testing the mail by trigger SQL server, price oil today is ='+@price

set @subject = 'Sending Mail using Database Mail'

END

//----------------------

Thank you.

Sitt of Thailand.