topic Re: Run a job based on value in database in Talend Studio

Run a job based on value in database

Anonymous — Tue, 16 May 2017 08:41:34 GMT

Hi ,

I want a job that runs only when there is a value present in one of the tables

For example - if the value col1 in select col1 from table is 'abc' then only will I execute the jobs.

Any ideas on this would be of great help

Thanks

Rathi

Re: Run a job based on value in database

TRF — Tue, 16 May 2017 08:56:28 GMT

Hi,
You need to start the job periodicaly, query the table and if the value doesn't match the expected value, stop the job using a tDie.

Re: Run a job based on value in database

Anonymous — Tue, 16 May 2017 09:06:14 GMT

I may be misunderstanding this question, but are you asking for a way to identify which job to run by the data in your database? If that is the question, you can use the "Use Dynamic Job" functionality of the tRunJob component. Essentially you need to have a parent job which runs a query on your DB. Depending on what it returns the job can select which child job to get the tRunJob to run.

Re: Run a job based on value in database

Anonymous — Tue, 16 May 2017 10:55:15 GMT

Hi ,

I will explain a little in detail. Let's say I have a job j1. This job must run only if the value select col1 from table = 'abc'.

If the value does not match then it should not execute, I don't want any error generated.

So, if

value matches

then

execute job

else

do nothing

end if;

Thanks

Rathi

Re: Run a job based on value in database

Anonymous — Tue, 16 May 2017 11:22:13 GMT

You can do this using what @TRF suggested, but don't use the tDie. Just use conditional logic (using RunIf links) based on the success or failure of the query. If the query returns the value you want, go down the RunIF pointing to the tRunJob used to run this job. If it doesn't, do nothing.

Re: Run a job based on value in database

TRF — Tue, 16 May 2017 11:23:38 GMT

OK, so you can go with the proposition I made on top of this topic, it's enough.

You just have to decide the scheduling to start the job when needed.

Re: Run a job based on value in database

Anonymous — Wed, 17 May 2017 08:52:05 GMT

Hi, thanks for the reply.

I am trying to do this.

tmssqlinput --> tmap --> tjava --runif --> tsendmail

in tmssqlinput I have the query, "select [Values] val from lookupvalues where tablename = 'ETLSource'" which returns the value "devsprint13"

in tjava I have the code as context.source= row1.val;

In runif the code is "devsprint13".equals(context.source)

When I run the job, the runif returns a false.

When I try to see the output of tjava using a tlogrow the context.source has no value assigned.

I don't understand why the value of the query output is not being assigned to context.source in tjava ( context.source= row1.val;)

Any ideas on this?

Thanks

Rathi

Re: Run a job based on value in database

Anonymous — Wed, 17 May 2017 09:18:43 GMT

Use a tSetGlobalVar instead of the tJava component. If you are not aware of this component, it allows you to set a hashmap variable from a column in the data row. To use this in the RunIf you would do something like this (assume the name of the variable is "myVar")....

globalMap.get("myVar")!=null && ((String)globalMap.get("myVar")).equals("devsprint13")

Re: Run a job based on value in database

Anonymous — Wed, 17 May 2017 09:27:30 GMT

Thanks I will try this out

But, may I know why this does not work with tjava?

Thanks

Rathi

Re: Run a job based on value in database

Anonymous — Wed, 17 May 2017 09:30:40 GMT

The tJava is not really an "on row" component *could* be one of the reasons. The context variable has not been properly assigned before testing the RunIf condition, *could* be another reason. I'd have to look at the job. But this way would be a better way of doing this. If this doesn't work you will need to check that your tMap is configured properly.

Re: Run a job based on value in database

Anonymous — Thu, 18 May 2017 06:59:23 GMT

Hi,

When I connect the tjava to a tlogrow then I do get the output as desired. Only When I have connected to RunIf the code always returns a false

The job design is as I have explained in my previous reply

Thanks

Rathi

Re: Run a job based on value in database

TRF — Thu, 18 May 2017 07:38:22 GMT

Can you a capture + the condition?

Re: Run a job based on value in database

Anonymous — Thu, 18 May 2017 08:27:01 GMT

Hi TRF, I am sorry I did not get what you are saying. You want me to give the condition in runif?

Re: Run a job based on value in database

TRF — Thu, 18 May 2017 08:54:13 GMT

Yes, it could be easier if we have a picture of the job and as you said the runIf link allways returned false, we need the condition you've written to try to help you.