Running v12.3
Hello,
I have an encrypted file server that I connect to with Automic RAFTP that is a source and/or destination connection. This file server is also connected to with other software. Over the last few weeks there has been errors in some of the jobs with the error "connection refused" or "connection timeout". I've done some changes on the server and on the other software to help the connections but at the end of the day I think it is merely contention due to the number of jobs hitting the server at the same time.
I want to list all RAFTP jobs that connect to the file server and when they are scheduled to run either with c_period or JSCH.
I built a base query to get the jobs but I can't find a table that has schedule information. Does anyone know what table to add to the below query to get the schedule information?
select distinct *
from (select o.OH_OType,
o.OH_Idnr,
o.OH_Name,
o.OH_client,
j.JBA_HostDst,
(select OCV_Value from OCV where OCV_OH_Idnr = o.oh_idnr and OCV_VName ='fromConnection') as from_connection,
(select OCV_Value from OCV where OCV_OH_Idnr = o.oh_idnr and OCV_VName = 'toConnection') as to_connection
from OH o, JBA j
where o.OH_Idnr = j.jba_oh_idnr
and j.JBA_HostDst in('HOSTG.OIT.RAFTP.AGENTS', 'OITRAFTP02')
and o.OH_client = '1') a
where a.from_connection like 'CONN.FTPAGENT.MOVEIT%'
or a.to_connection like 'CONN.FTPAGENT.MOVEIT%'
order by 3
------------------------------
Tim Osgood
Developer
State of Colorado
------------------------------