JohnO'Mullane

What Table in Automic DB contains a JSCH(Schedule) Calendar details

Discussion created by JohnO'Mullane on Nov 3, 2017
Latest reply on Nov 7, 2017 by Pete Wirfs
Hi,
On V12 can someone help me find the table within the UC4 database that contains the Calendar setting for a particular JSCH Object.

I have the Object Area Diagram for the JSCH object from V11.2 but I can't clearly see the table that contains this info.


n8euj0aecsmb.png


I can pull all the Keywords we use for a particular Calendar but I need to know which Schedule tasks this keywords are being used in .

select a. oh_name, b.okb_name, b.okb_validto 
from uc4.oh a, uc4.okb b
where a.oh_idnr = b.okb_oh_idnr
and a.oh_name = 'GLOBAL.XSJ_CALENDAR'


Thanks,
John.

Outcomes