How can I write a stored procedure to send an email on record insert and flag as email sent?

Question

I have a trigger on a table writing to a custom table. I would like an email sent when a record is added to this table. I believe there will also need to be an EmailSent flag added to the custom table to ensure records are only sent the once.

If SQL server, then consider https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-send-dbmail-transact-sql?view=sql-server-2017 — avery_larry, Oct 10 '19 at 21:40

Shawn Li · Answer 1 · 2019-10-11T02:50:25.513

0

Setting up a database mail first, then add a trigger for sending an email include new record and update EmailSent flag. Here is an example for SQL server: Send e-mail from a trigger

edited Oct 11 '19 at 02:50

answered Oct 11 '19 at 02:25

Shawn Li

1
1

How can I write a stored procedure to send an email on record insert and flag as email sent?

1 Answers1