|
SQL Anywhere includes system procedures for sending electronic mail using the Microsoft Messaging API standard (MAPI) or the Internet standard Simple Mail Transfer Protocol (SMTP). These system procedures are implemented as extended system procedures: each procedure calls a function in an external DLL.
To use the MAPI or SMTP system procedures, a MAPI or SMTP email system must be accessible from the database server computer.
The system procedures are:
xp_startmail Starts a mail session in a specified mail account by logging onto the MAPI message system
xp_startsmtp Starts a mail session in a specified mail account by logging onto the SMTP message system
xp_sendmail Sends a mail message to specified users
xp_stopmail Closes the MAPI mail session
xp_stopsmtp Closes the SMTP mail session
The following procedure notifies a set of people that a backup has been completed.
CREATE PROCEDURE notify_backup( )
BEGIN
CALL xp_startmail( mail_user='ServerAccount',
mail_password='ServerPassword'
);
CALL xp_sendmail( recipient='IS Group',
subject='Backup',
"message"='Backup completed'
);
CALL xp_stopmail( )
END
The mail system procedures are discussed in the following sections.
xp_startmail system procedure
xp_startsmtp system procedure
xp_sendmail system procedure
xp_stopmail system procedure
xp_stopsmtp system procedure
Return codes for MAPI and SMTP system procedures