Trigger to send email if a table has had a INSERT, UPDATE OR DELETE
We need a trigger to be sent out if ProcessSchedule has had an INERT, UPDATE or DELETE
We don’t need details just a heads up type of email.
The send email part is easy.
EXEC msdb.dbo.sp_send_dbmail @profile_name = ‘SQLMail’
,@recipients = ’email address removed for privacy reasons’
,@body = ‘Press Schedule Changed’
,@subject = ‘Press Schedule Changed’
The trigger part I have not done before.
Any help would be greatly appreciated.
We need a trigger to be sent out if ProcessSchedule has had an INERT, UPDATE or DELETE We don’t need details just a heads up type of email.The send email part is easy. EXEC msdb.dbo.sp_send_dbmail @profile_name = ‘SQLMail’,@recipients = ’email address removed for privacy reasons’,@body = ‘Press Schedule Changed’,@subject = ‘Press Schedule Changed’ The trigger part I have not done before.Any help would be greatly appreciated. Read More
