Have you seen WorkAlerts (www.workalerts.com).
It is nice. You build rules via point and click and can build custom
emails, pages, etc. of business information (or any other information for
that matter).
It has a built-in scheduler as well as the ability to automate.
You can pull information from multiple databases (of different types) and
build a nice message in real-time. Also it can be used to feed another
database with information based on some other condition. All this without
coding.
You should check it out. They have a free 30-day trial.