List of the jobs configured to run on a specific agent

Document ID : KB000069844
Last Modified Date : 02/07/2018
Show Technical Document Details
Question:

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

Answer:
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' ;