We have a scenario where Session failure emails are to be sent to different group of people depending on Environment like QA, PROD. This is our goal.
In my project, we already have some 200 workflows in all Environments.
We are using same mail group in all environment say email_group_x which was configured in outlook installed on informatica server. However because of this our Production Supprot team is receiving NonProd session failure mails also.
We already have an email task task_email_alert which is having email_group_x and referred by On Failure Email in session properties of almost all sessions.
We were asked to come with an approach for the solution. But, below are limitations for our approaches.
1. When we use parameter file, we need to edit all 200 workflows to configure for using parameter file by specifying paramfile path in each workflow. And if a particular workflow is already using a parameter file, I think its not possible to use another param file.
2. When we configure Integration service by setting email values to $PMFailureEmailUser, I heard that it will not work for sessions which have postSQL command. If its true, some of our sessions commonly use postSQL, so, we cant go for this as we need a unique solution.
Please suggest a solution such that without modifying individual workflows and by just editing the Email task task_email_alert we can achieve the goal.
Is there any concept like Repository level variables/parameters?
thanks in advance.