topic Re: Pass parameters to jobs when executing the .sh script in Talend Studio

Pass parameters to jobs when executing the .sh script

Anonymous — Sat, 16 Nov 2024 13:05:08 GMT

Hi -
Is is possible to pass a parameter (a date, for example) to a job when it is executed by running the .sh script, or when launched through the Job Conductor in the Admin Center? - using an Oracle database

Re: Pass parameters to jobs when executing the .sh script

Anonymous — Fri, 18 Feb 2011 08:00:40 GMT

Hi
Edit the .sh script and add the context parameters like:

cd `dirname $0`
 ROOT_PATH=`pwd`
java -Xms256M -Xmx1024M -cp classpath.jar: p3.executejob_0_1.ExecuteJob --context=Default --context_param name1=elise --context_param name2=shong $*

On Job Conductor, open the context tab and add the custom value. (see my screenshot)
Best regards
Shong

Re: Pass parameters to jobs when executing the .sh script

Anonymous — Tue, 22 Feb 2011 13:29:46 GMT

Thanks -

Re: Pass parameters to jobs when executing the .sh script

Anonymous — Tue, 22 Feb 2011 14:56:02 GMT

Hi -
I want to use the variable in the query field for a tOracleInput component. How do I modify the query to use it?
SELECT ...
FROM ...
WHERE LAST_MOD_DATE > context.TheDate

Re: Pass parameters to jobs when executing the .sh script

Anonymous — Fri, 29 Apr 2011 11:30:06 GMT

Hi -
I want to use the variable in the query field for a tOracleInput component. How do I modify the query to use it?
SELECT ...
FROM ...
WHERE LAST_MOD_DATE > context.TheDate

I assume LAST_MOD_DATE is some date so you will be including it in query in quotes. You will be appending this context param to your query. Your query will be then

"
SELECT ...
  FROM ...
WHERE   LAST_MOD_DATE > '" + context.TheDate + "'"

Re: Pass parameters to jobs when executing the .sh script

Anonymous — Wed, 04 May 2016 08:07:53 GMT

Hi I need to connect to Sever such as 192.168.137.12 and then login in that server with user name and password.. point to a location and then run a Shell script.. how to proceed with the same in Talend?? Some inputs pls..

Re: Pass parameters to jobs when executing the .sh script

Anonymous — Wed, 04 May 2016 08:36:31 GMT

Take a look at the component tSSH. This may be what you're after.