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' ;
Feedback
thumb_up
Yes
thumb_down
No