sp_processmail

(Windows only) Reads, processes, sends, and deletes messages in the SAP ASE message inbox, using the xp_findnextmsg, xp_readmail, xp_sendmail, and xp_deletemail system extended stored procedures (ESPs).

Syntax

sp_processmail [subject] [, originator [, dbuser
	[, dbname [, filetype [, separator]]]]]

Parameters

subject – is the subject header of the message. If you specify a subject but not an originator, sp_processmail processes all unread messages in the inbox that has the specified subject header. If you specify both subject and originator, sp_processmail processes all unread messages with the specified subject header sent by the specified originator. If you do not specify either subject or originator, sp_processmail processes all the unread messages in the SAP ASE message inbox.
originator – is the sender of an incoming message. If you specify an originator and do not specify a subject, sp_processmail processes all unread messages in the inbox sent by the specified originator.
dbuser – specifies the SAP ASE login name to use for the user context for executing the query in the message. The default is “guest.”
dbname – specifies the database name to use for the database context for executing the query in the message. The default is “master.”
filetype – specifies the file extension of the attached file that contains the results of the query. The default is “.txt”.
separator – specifies the character to use as a column separator in the query results. It is the same as the /s option of isql. The default is the tab character.

Examples

Example 1 – Processes all unread messages in the SAP ASE inbox with the subject header “SQL Report” submitted by mail user “janet”, processes the received queries in the salesdb database as user “sa”, and returns the query results to “janet” in a .res file attached to the mail message. The columns in the returned results are separated by semicolons:
```
sp_processmail @subject="SQL REPORT", @originator="janet", @dbuser="sa", 
	@dbname="salesdb", @filetype="res", @separator=";"
```
Example 2 – Processes all unread messages in the SAP ASE inbox as user “sa” in the master database and returns the query results in .txt files, which are attached to the mail messages. The columns in the returned results are separated by tab characters:
```
sp_processmail @dbuser="sa"
```

Usage

There are additional considerations when using sp_processmail:

sp_processmail reads, processes, sends, and deletes messages in the SAP ASE message inbox, using the xp_findnextmsg, xp_readmail, xp_sendmail, and xp_deletemail system ESPs.
sp_processmail sends outgoing mail to the originator of the incoming mail message being processed.
sp_processmail uses the default parameters when invoking the ESPs, except for the dbuser, dbname, attachname, and separator parameters to xp_sendmail, which can be overridden by the parameters to sp_processmail.
sp_processmail processes all messages as SAP ASE queries. It reads messages from the SAP ASE inbox and returns query results to the sender of the message and all its cc’d and bcc’d recipients in an attachment to an SAP ASE message. sp_processmail generates a name for the attached file consisting of “syb” followed by five random digits, followed by the extension specified by the filetype parameter; for example, “syb84840.txt.”
sp_processmail deletes messages from the inbox after processing them.
The subject and originator parameters specify which messages should be processed. If neither of these parameters is supplied, sp_processmail processes all the unread messages in the SAP ASE message inbox.
sp_processmail does not process attachments to incoming mail. The query must be in the body of the incoming message.

Permissions

You must have execute permission to run sp_processmail. The permission can be granted to other users by the database owner of sybsystemprocs.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Information	Values
Event	38
Audit option	exec_procedure
Command or access audited	Execution of a procedure
Information in `extrainfo`	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect