Update alarm_if_terminated attribute outside of jil

Products

• CA Workload Automation AE - Scheduler (AutoSys)
• CA Workload Automation AE

Issue/Introduction

Is there a way to update the alarm_if_terminated attribute of a job outside of jil to avoid a re-evaluation of the job's starting conditions?

Resolution

We do not typically encourage job definition updates to be done directly with sql. In most cases, it is not possible without corrupting the job definition. However, for this particular attribute, the update can be done via sql.

For a single job...

update ujo_sched_info set alarm_if_terminated=0 where joid in (select joid from ujo_job where job_name='job_name');

For a wildcarded job name...

update ujo_sched_info set alarm_if_terminated=0 where joid in (select joid from ujo_job where job_name like 'job_name%');