How can I determine which jobs an agent is assigned to?

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

How can I determine which jobs an agent is assigned to?

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Symptoms

 

How can I determine which jobs an agent is assigned to?

---

Cause

 

Applications Manager does not have a default report to showthis information. However, an SQL selectstatement can be used to determine which jobs are assigned to a givenagent/agent group. 

 

---

Resolution

 

Two generic statements are included below. They should berun while logged in the database as the AM user. The first generates a list of jobs and theagent/agent groups they are assigned to. The second generates a list of agentgroups and their agents.

 

 

 

Generates a list of jobs and the Agent/Agent Group they runon:

 

select a.so_module, a.so_command_type, a.so_oper_seq, b.aw_agentgrp_name
from so_job_table a, aw_agent_agentgrp_detail_view b
where a.so_oper_seq=b.aw_agentgrp_seq
order by a.so_oper_seq;

Generates a list of Agent Groups and their Agents:

 

select AW_AGENTGRP_NAME,AW_AGENT_NAME,AW_AGENT_FACTOR,AW_AGENT_PRI
from AW_AGENT_AGENTGRP_DETAIL_VIEW
order by 1,2;

 

 

 

Note: We recommend backing up the database before making anychanges/alterations.