If you are unable to create a new account, please email support@bspsoftware.com

 

How to sent an email alert in Cognos Data Manager ???

Started by bhanu.samas, 08 Jun 2012 12:30:52 PM

Previous topic - Next topic

bhanu.samas

Hello,
I am new to Cognos Data Manager and we have a issue now. In job streams once after execution we have to send an email alert with success or failure notification. My question is how to define condition in a email node. I think we need a varaible or something to store the result (Success/Failure) from the stage and this result triggers corresponding notification (success / failure email alert). Can anyone please help me with this?

Thanks,

Regards,
Bhanu.

MFGF

Hi,

You need to use a condition node to determine the success or failure. Every node in a jobstream automatically sets a boolean result into a variable called RESULT, and you can check this in your condition node - a TRUE means success and a FALSE means failure. You can then have your condition node linking to two email nodes - one for the True result and a different one for False.

One other hint is that you will need to change the Action on Failure of the receding nodes to be "CONTINUE", or else a failure in one of them will terminate the current processing leg in the jobstream.

Cheers!

MF.
Meep!

bhanu.samas

Thanks MF,
I used the following snippet at condition node

if $Resullt
then
Return TRUE;
else
Return FALSE;



MFGF

You could simplify that. Since the result variable is boolean anyway, your condition node could simply be coded as:

return $RESULT;

Remember that variable names are case sensitive. By default the result variable is defined in upper case.

Cheers!

MF.
Meep!