Is there a way to find out from Autosys server where unicenter SAP adapter installed client hosts?

Document ID : KB000045411
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction/Summary: 

How can we find out on which machines the Unicenter SAP adapter is installed.

 

Background:  

We are submitting jobs from Autosys to SAP environment using the Unicenter SAP Adapter.

 

Environment:  

Autosys 11.3.x - Unicenter SAP Adapter 3.2

 

Instructions: 

There is no direct way or command to obtain this information from Autosys database.

However you can use following SQL statement to find all jobs that are submitted to a machine having the Unicenter SAP adapter installed:

select job_name, mach_name from ujo_job where joid IN (select joid from ujo_command_job where command like '%sapjob%');