How can I determine which jobs an agent is assigned to?
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.
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
order by a.so_oper_seq;
Generates a list of Agent Groups and their Agents:
order by 1,2;
Note: We recommend backing up the database before making anychanges/alterations.