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

Document ID : KB000014378
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

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

Question:

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.

Answer:

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);