Seeking a utility to find jobs with date conditions with no StartJob

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent

Issue/Introduction

Seeking a utility to find jobs with date conditions with no StartJob

It seems that sometimes we can have a job that was running on a schedule that for an undetermined reason stops running.  We are looking for a proactive way to find and report on these jobs in this state.

Environment

Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option
Component:

Resolution

There is no such utility offered.  You can use the sql query: 

select job_name,status,next_start from aedbadmin.ujo_jobst 
where date_conditions=1 and status=4 and job_name 
not in (select job_name from aedbadmin.ujo_event where event=107);