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?
Release : 11.3.6
Component : WORKLOAD CONTROL CENTER
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:
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:
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.