Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
08-06-2013, 10:44 PM #1
- Join Date
- Aug 2013
- Thanked 0 Times in 0 Posts
Sql 2008 query trigger email to user
I need to trigger an email to user when a work order due date is approaching 1 day prior to the due date. Also I need to trigger when a user adds, delete, or modify work order to check on work order due.
Not sure how to query it in SQL. Thanks in advance.
Due Date = NeedByDate
user = AssignedTo
08-06-2013, 10:48 PM #2
Probably best to ask this in a SQL-Server specific forum.
I know that SQL Server, *can* send emails, but I've never done it. I know it takes careful setup to make it work.
Try http://www.sqlteam.com for example.
Or try MS itself: http://social.msdn.microsoft.com/For...gory=sqlserver
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.