Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

configuring FDMEE to send out email notifications after job completion or failure

ORAHYPFDMApr 5 2017 — edited Apr 6 2017

Hello Experts,

I have written the AftrConsolidate event script and tried loading data. Data Load seems successful, but I can't see any emails.

Do we have any sample script for this?

I have written the below script:

import com.hyperion.aif.scripting.API as API

import java.sql.DriverManager.getConnection

import smtplib

import string

strFromAddress = "abc@xyz.com"

strToAddress = ["aaaaaaaa@xxxxxx.com"]

strSMTPServer = "smtp.*******.com"

strMessage="Email Send"

stat = fdmAPI.getProcessStates(fdmContext["LOADID"])

if str(stat["IMPSTATUS"]) == "0":

try:

smtpServer = smtplib.SMTP(strSMTPServer,587)

smtpServer.ehlo()

smtpServer.starttls()

smtpServer.sendmail(strFromAddress, strToAddress, strMessage)

fdmAPI.logInfo("Email Sent successfully")

except Exception, e:

fdmAPI.logInfo("Error :email not sent" + str(e))

___________

Is there any missing?

Regards

Nishant

This post has been answered by ORAHYPFDM on Apr 6 2017
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 4 2017
Added on Apr 5 2017
4 comments
621 views