Contents Index xp_startmail system procedure xp_sendmail system procedure

ASA SQL Reference
  System Procedures and Functions
    System extended stored procedures
      Extended stored procedures for MAPI and SMTP

xp_startsmtp system procedure

Function 

Starts an e-mail session under SMTP.

Syntax 

[ [ variable = ] CALL ] xp_startsmtp (

smtp_sender = email_address

, smtp_server = smtp_server

, smtp_port = port_number ]

, timeout = timeout ]

)

Permissions 

Not supported on NetWare.

Description 

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.

Return codes 

For a list of return codes, see SMTP return codes.


Contents Index xp_startmail system procedure xp_sendmail system procedure