Check two conditions, send email to different lists?

talendtester — Fri, 22 Jul 2016 20:09:25 GMT

I have two different databases that I want to monitor for low free space.

Currently, I check both and send a single email to a list. There are people who only want to be on the email notice list for one of the databases.

How can I check database 1 and send an email to list 1 and check database 2 and send an email to list 2 in the same job?

The way I was only sending an email if the size was too low was checking using an if statement in a tJavaFlex.
If the size was ok for both then I did System.exit(0); to end the job else the email was sent.

If I make a tSendMail_1 and a tSendMail_2 how can I continue to the next tJavaFlex after checking the first database without sending an email if the size is ok? Is there something like System.nextStep so the job goes to the next subjob in the job?

tJavaFlex_2 > tSendMail_2
^
tJavaFlex > tSendMail_1

Re: Check two conditions, send email to different lists?

Anonymous — Sun, 31 Jul 2016 10:48:43 GMT

Hi
Using runIf connector to fire tsendMail component based on the checking result? For example:
tJavaFlex1--runIf1--tsendmail1
|
onsubjobok
|
tJavaFlex2--runIf2--maintsendmail2

on tJavaFlex1:

check first database and put the result to a boolean global variable, eg:
if(size>0){
globalMap.put("isOK", true);
}else{
globalMap.put("isOK", false);
}

Set the condition of runIf1 as:
!(Boolean)globalMap.get("isOK")

Regards
Shong

topic Check two conditions, send email to different lists? in Talend Studio

Check two conditions, send email to different lists?

Re: Check two conditions, send email to different lists?