Send Messages

Messages from Adaptive Server (outgoing messages) can be either text or formatted query results.

The Adaptive Server capability for e-mail greatly increases the potential usefulness of a stored procedure or trigger. For example:

A user-defined stored procedure that registers a new employee in the company database can include commands that send e-mail messages to a new employee and to other departments that need to be aware of the new hire, such as facilities, human resources, and training.
A trigger on an inventory table can send an e-mail message to inform the purchasing department that an item needs to be reordered when an update causes the number of items on hand to fall below a certain level.
A weekly report generated from a database query can be produced automatically and sent to a mailing list.