Session Failure emails

Here is a reusable email task you can use for the “On Failure E-Mail” property for any Informatica session. If the session fails an email is sent to an address you specify. The content of the email is generic but you get all relative information about the session’s failure, plus the session log as an email attachment.

Download the task and import it into a PowerCenter folder. Next set the “On Failure E-Mail” for a session to "reusable" and chose the email task.

You may have to edit the task and set the "To" email to whatever is valid for your environment.

Here is a brief overview of the variables used in the email content:

%s= Session Name
%d = Repository Name
%e = Session Status
%m = Mapping name
%n = Folder Name
%b = Session Start Time
%c = Session Completion Time
%i = Session Elapsed Time
%l = Total Records loaded
%r = Total Records Rejected
%t = Target table details
%g = Attach session log

I like to use %d in the subject line so I know at a glance which repository the failure email came from.

Below is an example of what the content of the email looks like:

Thank you for your support
 or  PayPal

IMPORTANT,  YOU are responsible for backing up your systems before trying or implementing any suggestions from this blog. I do not guarantee 100% accuracy of any code examples. I do not presume to know your system environment(s) or Security requirements; all code examples from this blog should be thoroughly tested before any attempted use on a production system.

1 Response to "Session Failure emails"

  1. Anonymous 6/2/11, 10:37 AM
    Not able to download the task from thh links provided above.

Post a Comment