ODI Load Plan Success Email with Execution Log File Attached

This post explains the process to unload ODI session log information Ex:  Session name, run-time, number of records inserted etc. from SNP_SESSION table to a delimited file and attach it to a Load Plan success notification email.

This attachment can be used to identify the Session’s which are running longer than usual and causing performance issues, identify unusual number of inserts, deletes, updates done by a session.

Process:

• Create ‘Loadplan_Success_Notification’ package which uses ODISqlUnload utility to unload ODI session log information from SNP_SESSION table and write into Delimited file, OdiSendMail utility to send email to distribution list with Execution log attached.
• Add ‘Loadplan_Success_Notification’ package at the end of Load plan.

Revolutionize Your Business With Generative AI

From product design and software development to virtual agents, content creation, and reporting, GenAI is transforming business. Our AI experts help you unlock GenAI’s full potential and drive growth.

Let’s Get Started

Steps:

Create new package ‘Generate Load Plan Success email with Execution Log’ and Drag OdiSqlUnload utility from ‘All’ or ‘Files’ folder into package.

Enter OdiSqlUnload parameters as below

Drag OdiSendMail utility from ‘All’ or ‘Internet’ folder and enter OdiSendMail parameters as below

Save package and generate scenario.

Open load plan and add the scenario of package created above as last step in load plan.

Once all steps in Load plan are executed successfully, Package ‘Generate Load Plan Success email with Execution Log’ will be executed and email will be sent to distribution list with execution log attached in delimited file.