I'm hit by a feature requested from my customer. They are a bank and they need to monitor their ATMs. They want an SMS to be sent to administrators that will show "total remaining cash" in the machine at the end of each day.

They've given me an SQL Query that reads the database for this value (total remaining cash) but I'm wondering how do I make an SMS be sent daily at certain time, rather than at certain event.

All I know that AppManager is event-driven system which will alert based on status change (not at certain times), but also I know it is extremely flexible to conver this need.

Any thoughts will be much appreciated. Thanks in advance.

Rgds,
Mohmmad