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.

Find autosys job definition changes

book

Article ID: 212153

calendar_today

Updated On:

Products

CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

We are trying to find out if we can identify when did the job definitions changed and by who. Please advise how can we find that? If we need to query the repository, please let us know what tables need to be queried to get this information.

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

If you have autotrack enable then you can run an autotrack report to find out who made change to job definition.  For details, see the documentation of autotrack at the following URL:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/workload-automation-ae-and-workload-control-center/11-3-6-SP8/reference/ae-commands/monitor-and-report-on-workload/autotrack-command-tracks-changes-to-the-database.html

If autotrack is not enabled, try querying ujo_job table for the following fields/columns:

joid
job_name
is_active
is_currver
job_ver
create_stamp
create_userid
update_userid
update_stamp