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

  • 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!

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

  • 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

  • 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