Manual Configuration of Email Notification for Scheduler Batch Execution

This chapter provides information how to manually configure the SMTP settings.

Prerequisites

• Database access privileges to update the configuration schema.
• Knowledge of your SMTP server's host name and port.

To manually enable email notifications for OFS MMG, administrators must populate the SMTP configuration details into the AAICL_SC_COMPONENT_DETAILS configuration table present in the OFS MMG configuration schema. This is required for environments running versions of OFS MMG released prior to the automated installer enhancement.

Execute the Insert Statements

Replace {{<smtphost>}} and {{<smtpport>}} with your actual SMTP server host name and port number.

INSERT INTO AAICL_SC_COMPONENT_DETAILS

(V_COMPONENT_ID, V_PROPERTY_ID, V_PROPERTY_VALUE, V_CREATED_BY, D_CREATED_DATE, V_MODIFIED_BY, D_MODIFIED_DATE)

VALUES

('AAICL_EMAIL', 'host', '<smtphost>', NULL, NULL, NULL, NULL);

Validate the Configuration

Verify the entries by using a SELECT statement:

SELECT * FROM AAICL_SC_COMPONENT_DETAILS WHERE V_COMPONENT_ID = 'AAICL_EMAIL';