In Job sequence i need to call the parameters from table. How to call suitable parameter for particular job
How to do this???
Can you please give me suggestion for this
Thanks in advance
sequencer
Moderators: chulett, rschirm, roy
You need to call parameters from what table? Could you please elaborate on your question. If you want to pass parameters to a job from another job with in Job sequence you could try using the "User Variables Stage" or it totally depends on your requirement. It would help us to help you in a better way if you could be more clear
Kris.
Kris.
In Jobs what are the parameters i am passing for particular job, we need to insert thats parameters into table from the table we need to call the parameters to run job sequence
the job sequence has to run in different envinorments suppose its running in development need to get the paramaters from development table, in production get the parameters from production table(paramater)
In Job Sequence get the parameters from Table
Thanks
the job sequence has to run in different envinorments suppose its running in development need to get the paramaters from development table, in production get the parameters from production table(paramater)
In Job Sequence get the parameters from Table
Thanks
samba
Hope you are calling the Job sequence from a unix script.
If so export the parameter and its value to a file. Read it through the script and pass it to the Job sequence for each environment, say DEV, or PROD.
And inturns from Job sequence to the underlying jobs.
If so export the parameter and its value to a file. Read it through the script and pass it to the Job sequence for each environment, say DEV, or PROD.
And inturns from Job sequence to the underlying jobs.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is nothing within a job sequence that allows you to access a table. A job sequence processes no data whatsoever; it prescribes the flow of control.
Probably your best solution is to construct a job (a server job would do) to retrieve the values then use something like that job's user status area, a routine or a command or a User Variables activity - depending on where you put the retrieved values - to bring them into your job sequence.
Probably your best solution is to construct a job (a server job would do) to retrieve the values then use something like that job's user status area, a routine or a command or a User Variables activity - depending on where you put the retrieved values - to bring them into your job sequence.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 15
- Joined: Tue Apr 20, 2004 3:10 am
[quote="ray.wurlod"]There is nothing within a job sequence that allows you to access a table. A job sequence processes no data whatsoever; it prescribes the flow of control.
Probably your best solution is to construc ...[/quote]
*******************************************************
In your job sequencer make an extra job which is your first job in the sequencer which reads the parameters from tha table and writes to a flat file.
You can as well call a unix script in the sequencer.
let me know if you need more info.
Probably your best solution is to construc ...[/quote]
*******************************************************
In your job sequencer make an extra job which is your first job in the sequencer which reads the parameters from tha table and writes to a flat file.
You can as well call a unix script in the sequencer.
let me know if you need more info.