Parameters
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 12
- Joined: Mon Sep 08, 2008 12:40 am
- Location: Hyderabad
Parameters
I have parameters in a table. how can i link the parameters table to the job?
Shirishareddy
If you explain what you mean by "link" you would get a better answer. This type of functionality has been done often in the past - but there are many means of solving it.
Usually you have a Job Sequence which calls a job that access the tables to get the appropriate parameter values. These are then either passed back to the job sequence directly or written to disk and then used to call subsequent jobs with the appropriate values.
Not incredibly complex, but not quite trivial, either.
Usually you have a Job Sequence which calls a job that access the tables to get the appropriate parameter values. These are then either passed back to the job sequence directly or written to disk and then used to call subsequent jobs with the appropriate values.
Not incredibly complex, but not quite trivial, either.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
How can we pass the values fetched from the job directly to the sequence?ArndW wrote:If you explain what you mean by "link" you would get a better answer. This type of functionality has been done often in the past - but there are many means of solving it.
Usually you have a Job Sequence which calls a job that access the tables to get the appropriate parameter values. These are then either passed back to the job sequence directly or written to disk and then used to call subsequent jobs with the appropriate values.
Not incredibly complex, but not quite trivial, either.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Many ways. The easiest is to use a server job and put the values into the job's user status area. You can write them to a file and have the sequence job read the file. And so on.
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: 12
- Joined: Mon Sep 08, 2008 12:40 am
- Location: Hyderabad
Hi
i have 30 jobs, for all the jobs i need to pass 100 parameters to all the jobs.
This all parameters are in one table, so how ccan i call the table to all the jobs. I need this at job level ,not sequence level.
This all parameters are in one table, so how ccan i call the table to all the jobs. I need this at job level ,not sequence level.
Shirishareddy
As has been answered twice in this thread already, you need 2 steps, the first to get values from your table and the second to use those values to call jobs. You cannot set parameter values inside the job that uses those values, therefore you need a sequence that does this work and then calls the job.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA