Initiating an action on another program

[Psychlotron]

Hi, I've designed an Order Entry System and now I'd like to send an email when an Order has been saved to the Database. I could probably do it from the client machine pretty well, but really what I was looking for was to inform another program running on the server that an Order has been saved into the database with OrderID:xyz. And have that program take care of sending the email. I have no problem designing this second program, in terms of the basics of responding to an event and sending an email. But my question is: how do I raise an event across the network that this other program will respond to?

Thanks,
Jerome

[Negative0]

Create a new table in the database to track emails that need to be sent. Then your second app monitors that table and sends an email when new rows show up. It then marks those rows as being sent.

This helps you out if for some reason the email process is down, when it comes back up, it will start sending the emails again.

[Psychlotron]

negative0,

Thanks for the suggestion. Sounds like probably the simplest solution.

-Jerome