Method to filter CA7 Agent jobs by Agent name

Products

• CA 7 Workload Automation

Issue/Introduction

How can I get a list of jobs that run on a specific system agent from CA 7 r12?

Environment

Release:
Component: 7

Resolution

To select all jobs and the agent name the jobs run on use the following SQL 

SELECT JOB, AGENT_NAME FROM CA7_JOB 
WHERE DB = 'logical_database_name' 
AND AGENT_TYPE <> 0 ; 

To select all jobs that run on a specific agent, use the following SQL

SELECT JOB FROM CA7_JOB 
WHERE DB = 'logical_database_name' 
AND AGENT_NAME = 'agentname' ;