Automic Workload Automation

Expand all | Collapse all

How can I report on how many JOB* objects have executed in 24 hours

Jump to Best Answer
  • 1.  How can I report on how many JOB* objects have executed in 24 hours

    Posted 06-07-2018 10:04 AM

    I've been asked to report on the number of JOB* objects that execute over a 24 hour period.

    Tried the statistic but no output as over 20000 executions.

    Can anyone assist?



  • 2.  Re: How can I report on how many JOB* objects have executed in 24 hours

    Posted 06-07-2018 01:14 PM

    I run queries like this one against the AH table.  You need to join it to the OH table to get to the object names.  And the timestamp columns are stored in GMT, so you need to adjust for that too.



  • 3.  Re: How can I report on how many JOB* objects have executed in 24 hours

    Posted 06-08-2018 05:02 AM

    Hi

     

    as a starting point you can use this one (ORA, AE V11.2)


    select distinct AH_CLIENT, AH_OTYPE, COUNT(*) OVER (ORDER BY  ah_client, AH_OTYPE)from ah
    where ah_otype in ('JOBS','JOBF','SCRI','JOBP')
    and ah_client in ('9999','9998')
    --FROM date
    and AH_TimeStamp2 >= to_date('2018-06-07 00:00:00','yyyy-mm-dd hh24:mi:ss')
    --until date
    and AH_TimeStamp2 <= to_date('2018-06-07 23:59:59','yyyy-mm-dd hh24:mi:ss')

     

    cheers, Wolfgang



  • 4.  Re: How can I report on how many JOB* objects have executed in 24 hours

    Posted 06-13-2018 03:57 AM

    Hi Wolfgang,

    as you know, any executable object that is executed gets a unique RunID. How can I count the number og unique RunIDs created per day?

     

    /Keld.



  • 5.  Re: How can I report on how many JOB* objects have executed in 24 hours

    Posted 06-13-2018 04:20 AM

    Hi Keld

     

    not sure, if I understand your request ?!?

    How can I count the number og unique RunIDs created per day?

    => Thats exactly the same - one Run ID per Dataset in the DB.

     

    If you want the Runid to be displayed simply add "ah_idnr" to the select.

     

     

    select distinct AH_CLIENT,ah_idnr, AH_OTYPE, COUNT(*) OVER (ORDER BY  ah_client, AH_OTYPE)from ah
    where ah_otype in ('JOBS','JOBF','SCRI','JOBP')
    and ah_client in ('9999','9998')
    --FROM date
    and AH_TimeStamp2 >= to_date('2018-06-12 00:00:00','yyyy-mm-dd hh24:mi:ss')
    --until date
    and AH_TimeStamp2 <= to_date('2018-06-12 23:59:59','yyyy-mm-dd hh24:mi:ss')

     

    order by ah_client, ah_otype

     

    cheers, Wolfgang



  • 6.  Re: How can I report on how many JOB* objects have executed in 24 hours

    Posted 06-13-2018 04:31 AM

    Hi Wolfgang,

    Sorry for not making myself clear enough...

    I mean, how to get the total number of 'executions', for all executable objects, including, EVNT, CALL, JSCH, JOBP and so on...



  • 7.  Re: How can I report on how many JOB* objects have executed in 24 hours
    Best Answer

    Posted 06-13-2018 04:36 AM

    Hi Keld

     

    ah now I understand, THX.

     

    just add all Object types to be considered ti the line:

    where ah_otype in ('JOBS','JOBF','SCRI','JOBP')

     

    cheers, wolfgang