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
I believe it was a command line autoaggr in 11.3 SP1.
Get Outlook for Android<https://aka.ms/ghei36>
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
Hi Gaurav,
Are you still looking for assistance/feedback on this? Can you mark suitable response as helpful/correct if it helped?
Thanks,
Chandru
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.
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.
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