ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Method to filter CA7 Agent jobs by Agent name

book

Article ID: 130847

calendar_today

Updated On:

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