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

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - System Agent (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• 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;