tips and tricks

UC4 Automic "Automatically deactivate when finished"

You can use following SQL to query "Automatically deactivate when finished" status from UC4 repository.

select OH_IDNR, OH_NAME,
CASE 
    WHEN JBA_AUTODEACT = 'A' THEN 'Always'
    WHEN JBA_AUTODEACT = 'J' THEN 'After error-free execution'
    WHEN JBA_AUTODEACT = 'N' THEN 'No'
    WHEN JBA_AUTODEACT = 'F' THEN 'After an error-free restart'
end as "Automatically deactivate"  
from uc4.oh t1,  uc4.JBA  t2
where OH_IDNR = JBA_OH_IDNR