PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
CREATE TRIGGER Food.AlertRequest ON Food.RequestMaster AFTER INSERT AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for trigger here @squery = SELECT * from RequestMaster EXEC msdb.dbo.sp_send_dbmail @profile_name = DBMail, @recipients = 'email@example.com', @query = @squery, @subject = @message, @attach_query_result_as_file = 1 ; END GO
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.