Message Queueing is good for asynchronous applications. You could employ a
queue in your solution, but it is not THE solution.
You have a time driven portion of an application. Given this, you need to
make sure an event happens when time hits a specific point. The basic method
is polling the table and determining if a specific time has been hit or
passed (and the event has not been completed - hint! hint! another field
needed in your table). This can be done in the database, or with a separate
program.
I would consider a windows service that polls the database on a regular
basis. Depending on how often you need this to check, this might not be the
best option, but it is fairly easy to accomplish. If you need messages sent
on the second a certain time is hit, rather than once a minute, for example,
you should look at facilities in the database or set up a separate system to
handle the message sends.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
*************** ************
Think Outside the Box!
*************** ************
"nestes" wrote:
I'm in need of a little direction, I've been tasked to create an app where
the user can store dates and times in a table (informix) and when that date
and time occurs send a popup message (like using net send computer_name
"message") to a select number of computers on our network. My question is
will messagequeue do this? I've read several articles about messagequeue but
nothing indicating that it sends a popup (like net send).
Thanks for any help provided.
