AutoSys Workload Automation

  • 1.  AggregateStatistics in Autosys

    Posted Jul 13, 2018 05:57 AM

    will the command work for sendevent -E AGGREGATE -l HOURLY/DAILY/MONTHLY/WEEKLY

    Autosys 11.3 SP1.
    We wish to generate a similar type of result that we get in Autosys 11.3.6 SP6 when

     AggregateStatistics is set to 1 in config.

     

    Thank you,

    Gaurav Kumar



  • 2.  Re: AggregateStatistics in Autosys

    Posted Jul 13, 2018 07:07 AM

    I believe it was a command line autoaggr in 11.3 SP1.

     

    Get Outlook for Android<https://aka.ms/ghei36>



  • 3.  Re: AggregateStatistics in Autosys

    Posted Jul 17, 2018 11:21 AM

    Hi Gaurav

     

    Please have a look at the following TecDoc

     

    https://comm.support.ca.com/kb/how-to-manage-aggregate-statistics/kb000029725

     

    I hope the response suits your need

     

    Thanks and best regards,

     

    Faouzia



  • 4.  Re: AggregateStatistics in Autosys

    Posted Jul 21, 2018 10:33 PM

    Hi Gaurav,

    Are you still looking for assistance/feedback on this? Can you mark suitable response as helpful/correct if it helped?

     

    Thanks,

    Chandru



  • 5.  Re: AggregateStatistics in Autosys

    Posted Jul 24, 2018 10:30 AM

    Hello Chandru,

    Thanks for the response, but the command autoaggr does not seem to return the data in the way that i want or i am unable to use it properly.

    Requirement is to generate a daily count of total number of jobs present in the environment as we currently get automatically in version  Autosys 11.3.6 SP6.



  • 6.  Re: AggregateStatistics in Autosys

    Posted Sep 01, 2018 10:06 PM

    Hi Gaurav,

     

    Are you referring to the $AUTOUSER/out/NumJobs*.csv and NumMachs*.csv files? These are generated by the Compliance Application which was introduced in WAAE 11.3.5.

     

    Thanks,

    Chandru



  • 7.  Re: AggregateStatistics in Autosys

    Posted Oct 08, 2018 06:06 AM

    Hi Gaurav

     

    So in short, you are just looking for the output of this sqlplus command with release 11.3?

     

     select count(*) from aedbadmin.ujo_job where is_active = '1' and is_currver = '1';

     

    Regards

    Jean Paul