WAAE: List of the jobs configured to run on a specific agent

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent

Issue/Introduction

In our environment we have thousands of jobs running on a very large number of agents.

We need to get the list of all the jobs configured to run on a specific agent machine by a database query.

 

 

 

 

 

 

 

 

Environment

WAAE 11.3.6 SP4 Release

Resolution

You can use the following query to get the list of all the jobs configured to run on a specific agent machine :

select JOB_NAME from AEDBADMIN.UJO_JOB
where MACHINE_NAME like 'agent_machine_name' ;