Method to filter CA7 Agent jobs by Agent name

book

Article ID: 130847

calendar_today

Updated On:

Products

CA Workload Automation CA 7 Edition

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