January 22, 2007 at 2:55 am
How can we send SMS for DML operations?
January 25, 2007 at 8:00 am
This was removed by the editor as SPAM
March 20, 2007 at 7:44 am
do you mean for Data Manipulation Language (DML) (such as insert, update, delete) - very simple - create a trigger that would send SMS in a case of update/insert/delete. - see my example at Send SMS from a trigger
Steve Jones - SSC Editor
March 20, 2007 at 7:58 am
Don't do this in a trigger. It's a bad use of triggers and can pause or hang the db. Use a trigger to log the event in a table. Then set up a job that queries the table and sends SMS msages.
Follow me on Twitter: http://www.twitter.com/way0utwestForum Etiquette: How to post data/code on a forum to get the best helpMy Blog: www.voiceofthedba.com
March 20, 2007 at 8:20 am
I agree with Steve, this would not be a good use of triggers, much better to have a job that queries the table than try to do too much on the insert
March 21, 2007 at 1:19 pm
I agree with all the above comments (including mine ) - I was only providing an example on/for SMS'ing
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply