In attached data sample, I have scheduled jobs.
I have get Calculate the success ratio of the Job Manager across 30000 lines per month
* When job is not successful and re-run within 24hrs/ before the next schedule job is its counted success, Failed Job will be Exclude and successful job would be Yes
* Unsuccessful/ Successful job will counted only once per " Policy "(Column K)
* When Scheduled Job Fails and Job is run "on-Demand" is success then its one Job count and Success(activity Type -Column (I))
*Duplicate Jobs for same day would be "DUP"