Messages from Adaptive Server (outgoing messages) can be one of two types:
Text
Formatted query results
Adaptive Server’s 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 reorder 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.
