Automic Workload Automation

  • Private Community
Back to discussions
Expand all | Collapse all

Is there a way to use a script to get a total number of objects executed during a specific period?

  • 1.  Is there a way to use a script to get a total number of objects executed during a specific period?

    Posted Aug 25, 2015 07:25 PM
    I would like to schedule a script to process on the first day of the month that can provide a total number of objects executed within the previous month. Does anyone know how this could be done? 


  • 2.  Is there a way to use a script to get a total number of objects executed during a specific period?

    Posted Aug 26, 2015 01:31 PM
    Hi Cynthia,

    I don't know any UC4 script that can accomplish this but with a simple SQLI variable you can get this information. Just create a SQLI VARA object and insert a query like the one below :

    select count(*) from ah where AH_OType in ('JOBS','JOBF','JOBP','SCRI','EVNT','CALL','JOBG','JSCH') and trunc(AH_TimeStamp1)=trunc(sysdate -30)

    Just make a script run a get_var on this variable on the first day of month and that's all.

    It's just an example considering some executable objects.

    Other option is to create a DB job if you need a more complex set of clauses.





  • 3.  Is there a way to use a script to get a total number of objects executed during a specific period?

    Posted Sep 01, 2015 12:53 PM
    Hey CynthiaDenning606758 , the DB.Reporting tool can generate the report for you.
    Here's a link to a post with the Whitepaper and discussions about it: Technical WhitePaper - Creating Reports using the UC4.DB Reporting Tool Utility