Automic Workload Automation

  • Private Community

  • 1.  [Quick Tip] How do I get a list / count of jobs that ran for a specific period?

    Posted Oct 10, 2016 05:41 PM

    To get a list / count of jobs (or any object) that ran for a specific period, you can run Statistics > Period, and enter the date range and time range (From/Until).

    The result is limited to 5,000 rows by default. You can increase this to 20,000 rows (max) in UC_SYSTEM_SETTINGS > GENERIC_STATISTICS_LIMIT.

    If your result is over 20,000, another option would be to run a query against the Automation Engine database.

    Example - SQL to get the list of all jobs that ran between Oct 5th and Oct 7th 
    You can modify the query below accordingly (base on what you're looking for)
    select oh.oh_client, oh_otype, oh_name,
    ah.ah_timestamp1 ActivationDateTime, ah.ah_timestamp2 StartDateTime, ah.ah_timestamp4 EndDateTime from ah, oh 
    where oh_idnr = ah_oh_idnr 
    and oh_otype in  ('JOBS') --- JOBS, JSCH, JOBP, EVNT, SCRI etc
    and (ah_timestamp1 > '2016-10-05' and ah_timestamp1 < '2016-10-07')



  • 2.  [Quick Tip] How do I get a list / count of jobs that ran for a specific period?

    Posted Oct 11, 2016 01:37 AM

    I think the so called Usage Statistic Tool is also a very good way to do such reports. Just have a look to this post:

    https://community.automic.com/discussion/comment/24072/#Comment_24072



  • 3.  [Quick Tip] How do I get a list / count of jobs that ran for a specific period?

    Posted Oct 11, 2016 04:58 AM
    Josef_Scharl_103 , Thanks for letting us know about it, it's interesting that I've never known about this tool before. Please let me know if there any online document / website which introduce about such a kind of tool or we just have to check it in download center. 



  • 4.  [Quick Tip] How do I get a list / count of jobs that ran for a specific period?

    Posted Oct 13, 2016 10:13 AM
    Thanks Josef.
    Additionaly, there is another thread similar to this, and the SQL has more details.
    See https://community.automic.com/discussion/7058/retrieving-the-list-of-tasks-that-have-been-executed

    Also, increasing the GENERIC_STATISTICS_LIMIT can have an impact on performance as mentioned in that thread.
    While this is very flexible, please be aware the modification(s) to the GENERIC_STATISTICS_LIMIT can have impact on overall performance. This is very quickly magnified in environments where there are a lot of users that do large amount of statistic reviews.