I want to send out an email when a workflow fails. I have configured the Suspension email option in General tab of the Workflow properties. To test this, I
deliberately fail one of the sessions to fail the workflow. No suspension email is sent out. Success email is working as part of my workflow. I am using PowerCenter 9.5.
Steps I took to create the suspension email:
1. created an email task.
2. made the email task reusable.
3. selected the email task from the Suspension email task browser.
Please let me know, if I need to configure anything else to get this to work.
You can try below way:
(1) Configure sessions to send post-session email:
You can configure the session to send an email when the session completes or fails. You create an Email task and use it for post-session email.
When you configure the subject and body of post-session email, use email variables to include information about the session run, such as session name, status, and the total number of rows loaded. You can also use email variables to attach the session log or other files to email messages.
(2) Configure workflows to send suspension email:
You can configure the workflow to send an email when the workflow suspends. You create an Email task and use it for suspension email. The Integration Service sends the email based on the locale set for the Integration Service process running the session.
You can use parameters and variables in the email user name, subject, and text. For Email tasks and suspension email, you can use service, service process, workflow, and worklet variables. For post-session email, you can use any parameter or variable type that you can define in the parameter file. For example, you can use the $PMSuccessEmailUser or $PMFailureEmailUser service variable to specify the email recipient for post-session email.
If you requires for testing purpose, edit e-mail task and follow below
Email User Name: firstname.lastname@example.org
Email Subject: Test e-mail
Email Text : Test
Thanks for your reply Venkat.
I believe my suspension email setup is correct, however the email is not sent out when the workflow fails. I am aware of the post-session email option, but do not want to go that route. I have about 20 sessions in one workflow and do not want to go and setup post-sesion failure emails on each one. I would rather have suspension email go out when any of the sessions fail.
Looking for further assistance on this issue. Thanks.
Have a look into below link.
I hope that helps you.