Command for fetching the list of jobs with a particular owner ID

book

Article ID: 192115

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - System Agent (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent CA Workload Automation AE

Issue/Introduction

There is no AutoSys command that will produce a list of jobs that have a particular owner ID defined in them.
Can we do obtain such a list thru a SQL query?

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

Here is an example of a SQL query that gives you a list of all jobs that have as owner 'autosys'.

select job_name from ujo_job where owner='autosys' and is_active=1 and is_currver=1;