See Also:Oracle Database Advanced Queuing User's Guide for detailed information about
This chapter contains the following topic:
This section contains the following topic:
Sets the host name for the SMTP server that the database will uses send out e-mail notifications
Sets the port number for the SMTP server
Sets the sent-from e-mail address
This procedure sets the host name for the SMTP server. The database uses this SMTP server host name to send out e-mail notifications.
This procedure sets the port number for the SMTP server.
As part of the configuration for e-mail notifications, a user with
AQ_ADMINISTRATOR_ROLE or with
EXECUTE permissions on
DBMS_AQELM package needs to set the port number before registering for e-mail notifications. The database uses this SMTP server port number to send out e-mail notifications. If not set, the SMTP mailport defaults to 25
This procedure sets the sent-from e-mail address. This e-mail address is used in the sent-from field in all the e-mail notifications sent out by the database to the registered e-mail addresses.