Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    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

  2. #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Thanked 4,947 Times in 4,908 Posts
    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
    Be yourself. No one else is as qualified.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts