Automic Workload Automation

  • 1.  Table containing RAFTP connections & paths

    Posted Nov 05, 2018 01:05 PM

    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



  • 2.  Re: Table containing RAFTP connections & paths
    Best Answer

    Posted Nov 05, 2018 01:20 PM

    I believe you want the OCV table



  • 3.  Re: Table containing RAFTP connections & paths

    Posted Nov 05, 2018 04:28 PM

    Thanks Michael.  That's the table I need. "object cit values" is not the most descriptive