Does anyone have any ideas on the best way to report on jobs in ESP that are running longer than normal? We would like to have some type of daily or weekly report that shows this information so we can build some trend charts.
Thanks for the response. Can you think of anything we can do by using history data to report on this...jobs running longer than normal? Maybe for some type of trending? Currently we do have some MAXRUNTIMEs set for a few jobs but not for many and we are looking something where we can report on any job that runs longer than the normal run time, now it may be ok that it did but need a way to report on this.
I wonder if you could use Report Server for this. Once it's gathering history, you could have a batch job that queried the history for jobs that ran over a certain length of time, then output that report in a way that you could use the data in Excel, Tableau, etc.
Thanks, currently we are not using Report Server but are looking to do so hopefully soon.
Firstly please post in the new link in the future:
CA Mainframe Workload Automation
The history report has following two fields:
So you may DISPLAY both fields, and if EXECQT is greater than AVGRUNT, then the run is longer than normal. Note: if you will need to use REPORTCV (instead of REPORT) and export the report to a excel and then do the comparison.
Hope this helps,
I moved this to the still somewhat new CA Mainframe Workload Automation community.
The only thing I would say with this one is AVGRUNT could get off I would think if you were to have a couple of long runs that were out of the norm.
What are you thoughts around that?
ESP doesn't have a way to exclude some runs of the same JOB.
Something you may consider to clear/ignore all the past runs:
- Remove the related JOBSTATS record for the JOB by running UTIL;
- Define and use JOBPROF for the JOB, so that the default profile by job name is not used.
- When possible, add job qualifier, like JOBAAA.1, then the default profile JOBAAA.1 will be used instead of JOBAAA.
Thanks Lucy, let me look at all of this.
Lucy, why does the AVGRUNT field contain a '-' at times?
EXEC Avg QTIME Run 1 - 2 -
Also can EXECQT and AVGRUNT be formatted differently?
The format of the two fields EXECQT and AVGRUNT can't be changed.
There are two common reasons that AVGRUNT shows the value of '-':
- The value is rounded to zero minute. See below on how AVGRUNT is calculated:
How is AVGRUNT calculated in the History Report fo - CA Knowledge
- The job is not submitted by ESP, so there is no JOBSTATS record for it. You can issue LJS JOB(jobname) I and see if it's the case.
As you may not know, actually AVGRUNT is also available on ESP CSF, enter PR, you can see "Average RunTime".