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

book

Article ID: 14378

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA 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);