Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » System Procedures » System extended procedures

System extended procedures Next Page

Extended system procedures for MAPI and SMTP

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:

The following procedure notifies a set of people that a backup has been completed.

CREATE PROCEDURE notify_backup( )
   CALL xp_startmail( mail_user='ServerAccount',
   CALL xp_sendmail( recipient='IS Group',
                     "message"='Backup completed'
   CALL xp_stopmail( )

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