List of undefined conditions

Products

• Autosys Workload Automation

Issue/Introduction

In changing job names, we have seen a number of undefined job conditions because a conditional job's name changed, but the condition did not.  

Is there a way to get a list of all undefined condtions?

Environment

Release : 11.3.6

Component : WORKLOAD CONTROL CENTER

Resolution

For 11.3.6.x options are:

 jil -V batch < jilfile.txt
 and look at the section 
 CAUAJM_W_50258 *** WARNING: The following Jobs have starting conditions that depend on nonexistent Jobs or Global Variables:
 
or 
 job_depends -J % -c
 and look for dependent jobs that have a status of *NOT_EXIST* 

NOTE - As of r12 AutoSys has a rename_job jil option.
That will help clients avoid situations like this as when you rename the job it renames the references of the job in other jobs dependencies.
For more details see:
https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/12-0/release-notes/ae-release-12/new-features-12.html
https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/12-0-01/reference/ae-job-information-language/jil-job-definitions/rename_job.html

NOTE - We do not encourage direct sql as the db is intended for the product's use
and client custom queries against it could potentially impact the database's
performance which then impacts the product's performance.
Additionally, the schema can and will change from version to version, so
what works today may not work later, after an upgrade.