AppWorx, Dollar Universe and Sysload Community

SQL query to get the Prior 3/4 months old job executions statistics

  • 1.  SQL query to get the Prior 3/4 months old job executions statistics

    Posted 08-05-2020 12:45 AM
    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')