Informatica Post Session Email Task

Since three years, I have been working in Informatica and I came across scenarios where we need to send Email on successful completion of Sessions or Workflows. But in some cases we not only send the successful status but we need to send session statistics also i.e. total rows loaded, total rows rejected etc.

Steps to create Reusable Email Task.

1) Go to components tag of session properties

2) Select reusable in the type field of Success or failure email

3) Click the Open button in the Value column to select the reusable Email task.

4) Note: If you edit the Email task, the edits only apply to this session.

Sample Post session Email:

Session: %s completed successfully..

Email Text -
Session Name– %s
Mapping – %m
Repo – %d

%l

%r

%e

%b

%c

Sample output of the above email task:

Session: s_sample completed successfully..

Session Name– s_sample
Mapping – m_sample
Repo – repo_dev

Total Rows Loaded = 1000

Total Rows Rejected = 0

Completed

Start Time: Tue Nov 30 08:26:00 2008

Completion Time: Tue Nov 30 09:27:11 2008

Following are the email variables that can be used with the email task:

Variable	Description
%a	Attach the named file. The file must be local to the Integration Service. The following file names are valid: %a or %a. The email does not display the full path for the file. Only the attachment file name appears in the email. Note: The file name cannot include the greater than character (>) or a line break.
%b	Session start time.
%c	Session completion time.
%d	Name of the repository containing the session.
%e	Session status.
%g	Attach the session log to the message. The Integration Service attaches a session log if you configure the session to create a log file. If you do not configure the session to create a log file or if you run a session on a grid, the Integration Service creates a temporary file in the PowerCenter Services installation directory and attaches the file. If the Integration Service does not use operating system profiles, verify that the user that starts Informatica Services has permissions on PowerCenter Services installation directory to create a temporary log file. If the Integration Service uses operating system profiles, verify that the operating system user of the operating system profile has permissions on PowerCenter Services installation directory to create a temporary log file.
%i	Session elapsed time (session completion time-session start time).
%l	Total rows loaded.
%m	Name of the mapping used in the session.
%n	Name of the folder containing the session.
%r	Total rows rejected.
%s	Session name.
%t	Source and target table details, including read throughput in bytes per second and write throughput in rows per second. The Integration Service includes all information displayed in the session detail dialog box.
%u	Repository user name.
%v	Integration Service name.
%w	Workflow name.
%y	Session run mode (normal or recovery).
%z	Workflow run instance name.