AutoSys Workload Automation

Hi

The customer has the the following requirement for a Job Summary report

Input data

Period for the report - Start and end date

Output data

Jobs grouped per Subapplication

Start & End Time for each report

Run time of each job (HH:MM:SS)

Average run time for each job during the time period specified

Any help will be appreciated

Klaus

Sorry to mention

We using CA WLA DE Version: 12.0.01.00 with integrated Postgres database

Hi Klaus,

Thank you contacting the CA Communities.   The Sub-application is a logical grouping.  So, the information of sub-application is kept with jobs only.  You can look in to ESP_GENERIC_JOB table and get the sub-application information from there.   Here is a sample query (I tested it on PostgreSQL):

SELECT job_name, subappl, start_date_time, end_date_time FROM ESP_GENERIC_JOB where subappl = 'MY_SUB_APPL' and APPL_ID IN (SELECT APPL_ID FROM ESP_APPLICATION where APPL_NAME LIKE '%MY_SPECIAL_APPLICATION%')

You can create a report using BIRT (in Desktop Client) and gather data accordingly.

Thank you,

Nitin Pande

CA Technologies