JohnO'Mullane

Update to "Max Parallel Task" directly on Database

Discussion created by JohnO'Mullane on Aug 30, 2017
Latest reply on Aug 31, 2017 by Wolfgang_Brueckler_1288
Hi,
I have a request to update ~100 Jobs and set the Max Parallel to 1 - abort.
Rather than edit each one I can do this via the Database by simply updating 2 columns on the OH table (oh_maxparallel2 + oh_maxwait) for each Job.

Automic database updates are not something I would recommend normally due to the complex structure and child tables, but in this case, I can't think of a reason not to.

Anyone disagree?

John.
 

Outcomes