Is there a way to query Workload Automation AE to get a listing of all jobs that have failed?
Workload Automation AE 11.3.6
Workload Automation AE keeps track of the jobs and their runs in the database. By default, 7 days of historical runs and events are kept. To see the run of a specific job one may issue a command like: autorep -J jobname -d. That would show the current run details. If there is a specific run number one is looking, add the -r <#> option. Example: autorep -J jobname -d -r 1234.
If the goal is to generate a complete list of all jobs that have failed one could use the monbro command to accomplish this.
First create the monbro definitions within jil. Here are two examples:
Then run them
monbro -N failure_monitor
monbro -N track_failure
In the example above failure_monitor will watch for new incoming failure events. The track_failure monbro will query the database and list all past failure events.
The same type of information can be extracted directly from the database but the format of the time will be in UNIX epoch time.
select j.job_name, r.startime, r.endtime, r.run_num, r.ntry, r.status, r.exit_code
from aedbadmin.ujo_job_runs r, aedbadmin.ujo_jobst j
and r.status in (5)
order by j.job_name,r.endtime;
NOTE: use "time0 -a <#>" to convert the times into a more human friendly display.
See the Workload Automation AE reference guide or wiki site for more details on monbro.