how can i give parameters i.e Third Party tools
or is there any command for giving parameters from outside the job
if possible Please explain me how it works
Parameters
Moderators: chulett, rschirm, roy
Re: Parameters
You mean while running a job from command line? Please check out the dsjob command ... search the forum ... this has been covered many times.laknar wrote:how can i give parameters i.e Third Party tools
or is there any command for giving parameters from outside the job
if possible Please explain me how it works
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
See, this is a sample command line invocation of a job through script :
which passes parameters RCPT_ID,STATUS to the job myJobName. Similarly you can pass in any number of parameters. In this example the value being passed is caught from the unix environment variables in place of which you could have read the parameter values from a parameter file and used those.
Code: Select all
dsjob -run -wait -param RCPT_ID=${RCPT_ID} -param STATUS=${STATUS} -jobstatus myProjectName myJobName
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.