Alerts with WebServices?

Hi all there..

I wanna Know it's posible to build and alert sistem whith Web Services..

Example.

I have on a table some price, it this price changes, a service raise and alert and send it via a websevice, and all clients that have it, can recive the alert..

Can web Services do this

Tanks for all.



Answer this question

Alerts with WebServices?

  • RMKelley

    Sure WS could if you wrote all the plumbing code. If I were you I would just implement a trigger on the table and then use your DBMS mail functions or an external EXE to send the alert to a list of people, either by email or pager or whatever.

  • André Phillip

    Hi,

    The solution is to add a trigger to the database table. You can then excute a the web service for notification.

    If you are using sql2005 there is a notification service you can use.

    Here is an article that can help you:

    http://davidhayden.com/blog/dave/archive/2006/04/25/2924.aspx

    Regards,



  • Alerts with WebServices?