Post reply

Send Email Alerts immediately depending upon data/text in a column

  • July 31, 2013 at 5:04 pm

    #296206

    Hi Experts,

    We do custom logging into a table. The requirement is that the developers should receive email immediately whenever there is specific data in that column

    Any Input is Appreciated

    Thanks a ton in adavnce!

  • July 31, 2013 at 10:25 pm

    #1637643

    Create a DML trigger and send mail using sp_send_dbmail based on the condition.

  • August 1, 2013 at 12:57 am

    #1637662

    SQListic (7/31/2013)

    Hi Experts,

    We do custom logging into a table. The requirement is that the developers should receive email immediately whenever there is specific data in that column

    Any Input is Appreciated

    Thanks a ton in adavnce!

    the previous poster advice is fine

    but i want to know is this required if it is un wanted data why not it handled on DB or applciation, what are you going to do with that.

    Regards
    Durai Nagarajan

  • August 1, 2013 at 12:21 pm

    #1637894

    A trigger would be the most 'immediate' way to do this, there will always be some mail server latency.

    I am not a fan of triggers so generally I will create a SQL Server job to check for a condition and run it at some interval. You'd have to consider whether this is immediate enough and whether the repeated polling of you logging table has any performance or server resource implications

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply