Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Send Email Alerts immediately depending upon data/text in a column Expand / Collapse
Author
Message
Posted Wednesday, July 31, 2013 5:04 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:04 AM
Points: 235, Visits: 976
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!
Post #1479740
Posted Wednesday, July 31, 2013 10:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 7, 2014 6:28 PM
Points: 2, Visits: 29
Create a DML trigger and send mail using sp_send_dbmail based on the condition.
Post #1479781
Posted Thursday, August 1, 2013 12:57 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
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
Post #1479802
Posted Thursday, August 1, 2013 12:21 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 4:49 PM
Points: 648, Visits: 3,800
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
Post #1480072
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse