sql server - Send automated email

Question

I want to send automated emails to UserType( requester, assignee ,reviewer,admin) based on an insert and.or update in Database.

EX:

A remainder email send to requester, assignee ,reviewer and admin if the reviewer is not able to review the data in 7 days from the date it is assigned to him/her.

I know I can do this with SQL JOB or with Windows Services. But I ma looking for different way to do this if possible and/or does SSIS provide such functionality?

Answer 1

I think another option is to setup the trigger on insert/update of tables that need to be monitored then then called a stored procedure that use msdb.dbo.sp_send_dbmail to send out email.

You can look at the answer in this post for reference on how to send email using sp_send_dbmail. Sending Email in SQL Server 2008 R2. I hope that helps.