Process Chain e-mail Alert
I am trying to set up an alert when the process chain is failed and in some cases I have send a mail at the start of the Chain, Success or Failure and Finish.
I have gone thru lot of threads and I got a bit of understanding however, they all are pointing to setting up a alert message after every process I.e after Info package, DTP, attribute change run etc. This is going to be too much of an effort because the way the process chain have been designed is as follows.
We have implemented LSA with three layes Acquisition, Data Propagation and Reporting Layer.
I will give a simple example of a data flow (its a flat file load).
1) Local Chain to Load to PSA
a) Load Info Package to PSA
b) load DTP to DSO (Write Optimised)
2) Local Chain to load to EDW
a) Load DTP to DSO (Standard DSO)
b) Activated DSO
3) Load to Reporting layer (Cubes)
a) Delete Index
b) Load DTP to Cube
C) Create Index
d) Roll up Aggregates
All most all threads which i have gone thru are pointing towards setting up of alert after every process step in the process chain, this way I will end up creating hundreds of erros messages which i dont want to do. Rather is it possible setup an error message only at the end of the each Local chain? this will reduce having too many mails shooting thru.
Also do we have to create a variant per alert? or can we use just one variant for all failed messages?.
Your help is appreciated.