SET_MAIL_PARAM

Modify specified REDADM Mail Parameter record.

Table: REDADM.ADM_MAIL_PARAMS (Email templates for the local schema)

Parameter Name	Properties	Default Value	Parameter Description
p_id	(PK)(NN)		Unique name of a notification email. Lua scripts use this ID as an identifier for sending the email.
p_subject	(NN)		Email subject
p_body	(NN)		Email body text. It may contain HTML tags and variables (e.g.: @{user_name}, @{ENV}, @{sbx_name}, …) that will be substituted by the calling LUA script.

Example

EXECUTE SCRIPT api_redadm.set_mail_param
            ( 'app_notify_loaded'                       -- p_id
            , '@{app_name} / @{bdate} is loaded'        -- p_subject
            , 'Dear RED User, please contact your RED Application Manager.'-- p_body
            );