ASA SQL Reference
System Procedures and Functions
System extended stored procedures
Extended stored procedures for MAPI and SMTP
Starts an e-mail session under SMTP.
[ [ variable = ] CALL ] xp_startsmtp (
smtp_sender = email_address
, smtp_server = smtp_server
[ , smtp_port = port_number ]
[ , timeout = timeout ]
)
Not supported on NetWare.
xp_startsmtp is a system stored procedure that starts a mail session for a specified e-mail address by connecting to an SMTP server.
email_address is the e-mail address of the sender
smtp_server specifies which SMTP server to use, and is the server name or IP address.
= port_number specifies the port number to connect to on the SMTP server. The default is 25.
timeout specifies how long to wait, in seconds, for a response from the server before aborting the current call to xp_sendmail. The default is 60 seconds.
xp_startsmtp starts a connection to a server. This connection will time out. Therefore, it is recommended that you start SMTP just before you want to execute xp_sendmail.
xp_sendmail over SMTP does not support attachments.
For a list of return codes, see SMTP return codes.