Manual Configuration of Email Notification for Scheduler Batch Execution

This chapter provides information on how to manually configure SMTP settings in the {{AAICL_SC_COMPONENT_DETAILS}} table to enable email notifications for the scheduler batch execution in OFS MMG. These instructions apply to environments running versions released prior to the automatic installer enhancement.

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);

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', 'port', '<smtpport>', NULL, NULL, NULL, NULL);

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);

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', 'port', '<smtpport>', 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';