This content has been marked as final. Show 3 replies
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