Tran-Hoang_Hau_348

Check Generate at Runtime for all JOBS

Discussion created by Tran-Hoang_Hau_348 on Jul 19, 2016
Latest reply on Jul 19, 2016 by Darren_Sniezak_40
Is there an easy way to cross check each and every job and workflow in a client and make sure "generate at run time" is ticked? 
If anyone need for other object, please post in this thread 
------------------------------------------------------

For the JOBS

View the current setting (generate at run time) if the value in “JBA_ActatRun”=0, which mean not checked

 SELECT  OH_name, JBA_ActatRun

from OH inner join JBA on OH_idnr = JBA_OH_idnr

where OH_client='1' and OH_OType='JOBS' and OH_DeleteFlag='0' and JBA_ActatRun is not null

Change the setting

 Update JBA set JBA_ActAtRun='1' where JBA_OH_Idnr in (select OH_Idnr from OH where OH_client='1'and OH_OType='JOBS' and OH_DeleteFlag='0');

  

For the Workflow

View the current setting (generate at run time) if the value in “JPA_ActatRun”=0, which mean not checked

SELECT  OH_name, JPA_ActatRun

from OH inner join JPA on OH_idnr = JPA_OH_idnr

where OH_client='1' and OH_OType='JOBP' and OH_DeleteFlag='0' and JPA_ActatRun is not null


Change the setting

 Update JPA set JPA_ActAtRun='1' where JPA_OH_Idnr in (select OH_Idnr from OH where OH_client='1'and OH_OType='JOBP' and OH_DeleteFlag='0');


Outcomes