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 hostname 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 that are running versions of OFS MMG that were released prior to the automated installer enhancement.

Execute the Insert Statements

Replace {{<smtphost>}} and {{<smtpport>}} with your actual SMTP server hostname 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 Configuration

Verify the entries using a SELECT statement:

SELECT * FROM AAICL_SC_COMPONENT_DETAILS WHERE V_COMPONENT_ID = 'AAICL_EMAIL';