xp_deletemail

Syntax

xp_deletemail [msg_id]

Parameters

• msg_id – is the message identifier of the mail message to be deleted.

Examples

• Example 1 – Deletes from the SAP ASE message inbox the message with the message identifier specified in the cur_msg_id variable:

  1> declare @cur_msg_id binary(255)
  2> exec xp_deletemail @msg_id = @cur_msg_id

• Example 2 – Deletes the first message from the SAP ASE message inbox:

  xp_deletemail

Usage

Obtain the msg_id using xp_findnextmsg.

If the msg_id parameter is not used, the message to be deleted defaults to the first message in the message inbox.

Permissions

By default, only a system administrator can execute xp_deletemail. A system administrator can grant this permission to other users.