Automic Workload Automation

  • Private Community
 View Only

  • 1.  List all jobs and their runtime stats.

    Posted Sep 05, 2017 06:42 AM

    Hi.

    I am using UC4 Operations Manager V8.

    I would like to get a list of all my jobs in UC4 as a list, showing their runtime and last status.  Is this possible and if so how?

    Thanks



  • 2.  List all jobs and their runtime stats.

    Posted Sep 05, 2017 06:53 AM
    Hello IanGoddard606749,

    I no longer have a v8 version to confirm this, but it looks like something you can get directly from the statistics.

    If you need the list of all objects then fastest way would probably be to query the AH table.

    Best regards,
    Antoine


  • 3.  List all jobs and their runtime stats.

    Posted Sep 05, 2017 06:59 AM

    Hi.  Thanks for responding.  How would I do this?




  • 4.  List all jobs and their runtime stats.

    Posted Sep 05, 2017 07:01 AM
    remembering 6 years back I think Reporting Tool was available in V8 as well.

    https://docs.automic.com/documentation/WEBHELP/English/AWA/11.2/AE/11.2/All%20Guides/help.htm#ucacha.htm?Highlight=reporting%20tool



  • 5.  RE: List all jobs and their runtime stats.

    Posted Jan 18, 2024 10:04 AM

    how to find the total number of UC4 jobs


    Original Message


  • 6.  List all jobs and their runtime stats.

    Posted Sep 05, 2017 07:47 AM
    Hi FrankMuffke : that's right, it already existed back then :)

    8rk9o7reya2j.pnghttps://us.v-cdn.net/5019921/uploads/editor/v5/8rk9o7reya2j.png" width="1162">

    Best regards,
    Antoine


  • 7.  List all jobs and their runtime stats.

    Posted Sep 08, 2017 11:49 AM
    The reporting tool will almost certainly meet your needs best.

    If you want more direct access, and have a good SQL developer and a safe environment to test queries, here's the v9 database structure: https://docs.automic.com/documentation/webhelp/english/ALL/components/AE/9.13/DB%20Schema//db/_structure/HTML/index.htm.  If you have any significant volume of history records, you're going to want to respect the indexes.

    AH table is the main history, and doesn't change much between versions (web menu only goes back to v9, but it's probably similar enough to v8). 

    But again, I would stick with the reporting tool if possible.