Hi,
We recently upgraded to DE R12.2. At the beginning of each month we run FAILED_JOBS report for previous month. For November we noticed it was much smaller than expected. We did expect it to be smaller as we didn't take history but it is still too small. Has anyone else noticed a difference in the FAILED jobs report? not sure if there is an issue or not.
When we run the
failed jobs report or this
sql we get 379 records (Nov 9 - today). Happy we get the same results with these 2 because essentially they should be the same.
However, we every job failure, suberror, overdue job triggers an alert that triggers an application ZZAUTOCUT and this alert was triggered
1119 times Nov 9 - today. We do use auto resubmit for many jobs and we only trigger the alert if final resubmit fails. This number should be smaller than the total number of jobs that failed. We have been tracking failed jobs and alerts for 2 years now so something changed.
379 records -
FAILED_JOBS report same results as sql Nov 9-today
379 – number of jobs in ESP_GENERIC_JOB that have a failed state. Because of auto resubmit we only cut tickets if final resubmit fails. This number should be less than number of times the ZZAUTOCUT application triggered
select WA.esp_APPLICATION.APPL_NAME,WA.esp_APPLICATION.APPL_GEN_NO,WA.esp_GENERIC_JOB.JOB_NAME,WA.esp_GENERIC_JOB.state,WA.esp_GENERIC_JOb.end_date_time
from WA.esp_APPLICATION,WA.esp_GENERIC_JOB
where WA.esp_APPLICATION.APPL_ID=WA.esp_GENERIC_JOB.APPL_ID
and (WA.esp_GENERIC_JOB.state like 'FAILED' or WA.esp_GENERIC_JOB.state like 'SUBERROR' or WA.esp_GENERIC_JOB.state like 'OVERDUE')
1119 – number of times our ZZAUTOCUT auto ticket cutting job ran
select WA.esp_APPLICATION.APPL_NAME,WA.esp_APPLICATION.APPL_GEN_NO,WA.esp_GENERIC_JOB.JOB_NAME,WA.esp_GENERIC_JOB.state,WA.esp_GENERIC_JOb.end_date_time
from WA.esp_APPLICATION,WA.esp_GENERIC_JOB
where WA.esp_APPLICATION.APPL_ID=WA.esp_GENERIC_JOB.APPL_ID
and (WA.esp_APPLICATION.APPL_NAME = 'ZZAUTOCUT')