3 Replies Latest reply on Apr 6, 2016 12:28 PM by SYED REHMAN

    Need to calculate Job's Average Run time by Schedule Type

    SYED REHMAN

      Hi follks,

      I want to calculate Average run time of Data Extract Refresh jobs by Type of Schedule e.g, currently what is average run time for all Hourly Jobs, Daily Jobs etc. I want to use this data to come up with some Benchmarking of Jobs by schedule time I-e how much maximum time we will allow our publisher to run their query based on a particular frequency they want to Refresh their data e.g, if they want their data to be Refreshed Every hour, we will ask them to optimize their query to finish with 2-3 minutes.

       

      I can get average run time from _Background_tasks view but am challenged joining this data with Schedules.

       

      Any help on this please

       

      Thanks

      Syed.