Hi,
Is there any alternative way of adding new job parameters or including new Environment variables to all the existing jobs ??
Adding Job Parameters to All Jobs
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
Adding Job Parameters to All Jobs
Share to Learn, and Learn to Share.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes.
You can hack the DS_JOBOBJECTS table. Of course you would need to know the structure of this table, which is not documented. Further, since the parameters collection location within the record is not in the file dictionary for DS_JOBOBJECTS an SQL-based approach is not available; it would have to be programmatic.
You can export the job(s) with default properties, add the new parameters, the import the job(s) overwriting their existing counterparts.
Each approach has its own special dangers.
You can hack the DS_JOBOBJECTS table. Of course you would need to know the structure of this table, which is not documented. Further, since the parameters collection location within the record is not in the file dictionary for DS_JOBOBJECTS an SQL-based approach is not available; it would have to be programmatic.
You can export the job(s) with default properties, add the new parameters, the import the job(s) overwriting their existing counterparts.
Each approach has its own special dangers.
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.