Hello and welcome to our community! Is this your first visit?
Register
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
    Posts
    1
    Thanks
    0
    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
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    26,561
    Thanks
    80
    Thanked 4,495 Times in 4,459 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
    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.


  •  

    Posting Permissions

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