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
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
|All times are GMT +1. The time now is 05:40 PM.|
Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.