I am trying to find all JOBS that have an RAFTP agent, the connection object it uses for the "From" and the Path it is accessing after making the connection.
Using the OH and JBA tables I get the job names and JBA_HostDst (my raftp agents). However, I can't find a table to get me the other information. I have looked through the Automic\Utility\db\_structure and run individual table queries without success. I will have to open hundreds of jobs to get this information and I know there has to be a better way.
Does anyone know the table(s) necessary to find this information?
Thanks