Hi ,
we are trying to get the Average Number of Job Executions for monthly but getting the 3 month job statistics correctly and need to get 3 or 4 months before job executions statistics , please help us to get the details through query /let us know the tables.
also let me know if we need to change any setups for getting the details.
PFB the query which we are using to get the satistics and also tried the same from AH table also.
SELECT COUNT (AJPP_OBJECT)
FROM uc4.ajpp
WHERE ajpp_otype = 'JOBS'
AND AJPP_STARTTIME BETWEEN TO_DATE ('14/06/2020 00:00:00',
'dd/mm/yyyy hh24:mi:ss')
AND TO_DATE ('14/06/2020 23:59:59',
'dd/mm/yyyy hh24:mi:ss')