Reporting using Autosys

[Rajadurai Pratap Kumar Viswalingam]

Hello Team , 

We need to fetch the Job statistics report on daily basis  from WCC (Reporting Tab). I wish to automate this process . Can any one help or suggest me to automate this process.

Is there any possible option to fetch the data using Autorep command.

------------------------------
Thanks and Regards
Pratap
------------------------------

[Yehonatan Amir]

Hey Rajadurai,

Not sure about using the Autorep  command , might be possible.

I'm not using the reporting functionality , but i think the data should be available inside the scheduler db. - you should use caution when handeling the DB , dont overload it :)

some more info could be found at :https://docops.ca.com/ca-workload-automation-de/11-3-3/en/monitoring-and-reporting/database-schema

Another option might be using selenium or other automated testing tool to produce the report daily.

Yoni

[Linda Williams]

Don't recommend doing any custom reporting straight from the database.  Anytime the database changes on future patches or upgrades, your whole process is then broken or suspect.

[LARRY GLANVILLE]

On Linux I run an autosys job to do that.

 

 

insert_job: AE_schedule_report   job_type: CMD

command: autorep -J ALL >/var/tmp/AE_Autosys_Report; echo "Attached you will find the latest Autosys Job Schedule  \

Report" | /bin/mailx -s "AE Autosys Job Schedule Report"  -a /var/tmp/AE_Autosys_Report  [e-mail]

machine: agent99

owner: autosys

permission: gx,wx

date_conditions: 1

days_of_week: su,mo,tu,we,th,fr,sa

start_times: "07:30"

description: "AE scheduled jobs"

alarm_if_fail: 1

 

Larry C. Glanville

 

[Linda Williams]

This will only give a full jil, the OP is looking for an automated way to send a wcc canned report.

[Steve Carrobis]

Originally the reporting tab used to be wrapped under the old BOXI product and that could be setup. Since they moved from BOXI to BIRT to I Think it is now JASPER. That functionality was lost. Before Broadcom i had an open request to bring that feature back. 
Yes i am old and have been using this product for a very long time.. 

Steve C.

[Steve Carrobis]

That is a very bad commandline process for autosys. That should be ,multiple jobs or one process in a properly coded wrapper.