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