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.
Release : 11.3.6
Component : CA Workload Automation AE (AutoSys)
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