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

Document ID : KB000090140
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
How can I determine which jobs an agent is assigned to?
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.