SAP CPS script to calculate the percentage of number of jobs completed

[former_member265210]

Hello

I have 2 client specific jobs, which I am executing on 300+ ABAP system using SAP CPS system. I would like to know..

what % of jobs completed successfully & failed.

at present, using the filter method, I get a consolidate jobs status mail. some think like this.

regards

Shridhar Gowda

[Former Member]

Hi Shridhar,

Redwood system maintains statistics for each job Definition.

In job statistcis you can notice Execution Completed Count  and Execution Error Count .

You can use Redwood script to pull those statistics

Use following methods to extract them.

getExecutionCompletedCount()

getExecutionErrorCount()

You can write code to get the error percentage and completed percentage.

Hope this helps.

[former_member265210]

Hello Ravi,

Thanks for that info.

do you have script to pull this info.

Regards

Shridhar Gowda

[Former Member]

Sridhar,

No I don't have.

You try following things

1. Query for final status jobs for certain period.

2.iterate through the loop.

3.assign following to long values

getExecutionCompletedCount().longValue()

getExecutionErrorCount().longValue()

4. Perform calculations.

5.Print to CSV report or test report.

Regards,

Ravi

[nanda_kumar21]

Option 1 :

Use Redwood script to create the report and introduce a counter to count the total jobs and the jobs with status completed. Then you can manipulate that data and get it in the report.

Option 2:

Generate a CSV report and use excel functions to do the calculations.

Thanks

Nanda

[abhishek_singh29]

Hi Nanda,

How about to create the dashboard or score card to calucate it.? I think Dashboard will be will the no of completed and error jobs for a timw window. Not sure how much it would help..

Cheers,

Abhishek