ETL, App Development and other tools > COGNOS DecisionStream/Data Manager

Add notification on Data Manager ETL

(1/3) > >>

jkabir:
Hi all,
I need help on adding a notification when my ETL job fail or success.

How and what logic should I use on email node or conditional node?

Thank you for your help.

MFGF:

--- Quote from: jkabir on 29 Aug 2019 02:35:34 pm ---Hi all,
I need help on adding a notification when my ETL job fail or success.

How and what logic should I use on email node or conditional node?

Thank you for your help.

--- End quote ---

Hi,

Within a JobStream, every node sets (by default) a boolean variable called $RESULT. If you set the action on failure of each node to "Continue", you can then use a condition node after the node you want to test - the expression you would use in the condition node would be
return $RESULT
The True output from the condition node would then progress to running the next node (success) or to an email node which you could use to send an email indicating success (if you wish to). The False output would link to an email node, which you could use to send an email indicating your failure.

Cheers!

MF.

jkabir:
Thank you for your answer.
Did you mean I would have to use both email and conditional node?
I am new to Data Manager. Could you  please help me with screenshot if possible?

MFGF:

--- Quote from: jkabir on 29 Aug 2019 03:13:01 pm ---Thank you for your answer.
Did you mean I would have to use both email and conditional node?
I am new to Data Manager. Could you  please help me with screenshot if possible?

--- End quote ---

Hi,

Yes - the Condition Node is used to test the RESULT variable and send the processing down either a TRUE or FALSE path in your jobstream. Email nodes are used to send emails, so you can have different emails by using two different email nodes in your TRUE path and your FALSE path.

Sadly I don't have Data Manager available to me at the moment, so I'm not able to send any screen shots. Just go to your Jobstream and bring in the required nodes, then link them using the linking tool (there is a button for this on the toolbar at the top).

Cheers!

MF.

jkabir:
Thanks a lot.
i am going to write only this return $RESULT;
to the action field in the condition node. Please see the attached pic for more info.

Navigation

[0] Message Index

[#] Next page