Oracle eMail Server Administrator's Guide Release 5.2 A86653-01 |
|
eMail Server provides scripts that help you automate routine tasks, such as collecting or replicating data. This chapter contains information on scripts for use with the eMail Server system, including:
eMail Server collects and stores information about the number and type of messages processed (sent) by the servers, and the number of messages received by users during a given time period. Using this data, you can create reports detailing items such as:
To begin collecting billing data, you must set the delivery_stats
, send_billing
, recv_billing
parameters of the postman process. The postman process manages your system's message routing tables and collects information about message traffic.
The Collector process automatically deletes data older than the number of days specified in the gc_billinfo_kept
parameter of the collector process. The default value is 45 days.
See Also:
"Parameters for Billing" for more information about setting the parameters available for billing |
To begin collecting information about the messages sent to your eMail Server system, enable the send_billing
parameter of the postman process. The default vaule of this parameter is 0
(diabled).
This task can only be performed through the OOMGR command-line interface.
IOFCMGR> register paramvalue server=postman
2>instance=<instance_value
> parameter=send_billing value=1;
See Also:
"Parameters for Billing" for more information about other parameters available for billing |
To begin collecting information about the messages received by your eMail Server system, enable the recv_billing
parameter of the postman process. The default vaule of this parameter is 0
(diabled).
This task can only be performed through the OOMGR command-line interface.
IOFCMGR> register paramvalue server=postman
2>instance=<instance_value
> parameter=recv_billing value=1;
See Also:
"Parameters for Billing" for more information about other parameters available for billing |
After you activate billing, the eMail Server system begins to collect billing data. You can retrieve the data using SQL scripts which query the views om_billing_sent_messages
and om_billing_received_messages
.
The following table shows the fields in the om_billing_sent_messages
view:
The following table shows the fields in the om_billing_received_messages
view:
Oracle eMail Server comes with a PL/SQL package to help administrators identify and remove specific messages system wide based on its sender, subject or attachment name. A script is also provided to use this package interactively through SQLPLUS. The most useful application of this script is to remove virus infected messages in the system. This package provides option to specify the time range within which the virus infected message has been entering the system, as well as an option to copy all these messages to a folder instead of deleting them immediately.
To use the SQLPLUS script, locate the file virusscr.sql under
$ORACLE_ HOME/office/admin/rsql, edit the file using a text editor and follow the instructions inside the comments (comments are text preceded by '--') to customize the script for your environment. It is recommended a backup copy of the original file is made for future references. After editing the script, run SQLPLUS as user oo.
By default the script output to a log file /tmp/virus.log, which can be customized by editing the virusscr.sql file manually.
Example: log file output10/20 17:04:13 INF: Processing message in range 16085 - 1608510/20 17:04:13 INF: Deleted 10 messages10/20 17:04:13 DIA: Finished processing messages beyond 11085If "move" is the chosen operation, all messages deleted by this script will also be copied into the target folder.
Server side rules is a feature of eMail Server that allows users, administrators or application developers to set up rules and filters for incoming email messages. Administrators can greatly benefit from this feature by setting up a variety of system wide email pocilies as rules, thereby greatly customize the server bevahior to suit the need of your particular requirements.
eMail Server comes with an example of such script, which can be used to set up a system wide rules to bounce back any incoming message if the recipient is over quota, thereby enforcing a hard quota policy. To use this script, locate the file bouncemsg.sql under $ORACLE_HOME/office/admin/rsql, run it using SQLPLUS as user oo.
Example: Script OutputSQL>@bouncemsgSelect rule management action item:(new/delete/disable/enable)[new]: newSelect action for over-quota messages(bounce/delete/both)[both]: bothold 7: IF '&&sel' = 'new' THENnew 7: IF 'new' = 'new' THEN...PL/SQL procedure successfully completed.
See Also:
the Oracle eMail Server Developer's Guide for more information on how to programmatically use server side rules. |
|
Copyright © 2001 Oracle Corporation. All Rights Reserved. |
|