asked on How do I write a SQL Server 2008 Stored Procedure
Here is what I am trying to do:
Send an e-mail when the value of a column 'SerialNo' is greater than 1500
Select wksNo, serialNo, from Tickets where serialNo > 1500
Send an e-mail when the value of a column 'SerialNo' is greater than 1500
Select wksNo, serialNo, from Tickets where serialNo > 1500
Microsoft SQL Server 2008
Last Comment
Guy Hengel [angelIII / a3]
ASKER
The issue is creating the trigger
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
* creating the trigger to do something
* sending email
* ...
I would create a trigger on insert/update, and put the primary key information into a table
a scheduled job, to be run every 5 minutes, would take the rows from that table, and send an email based on the information, and delete the rows on successful sending