I’m trying to create an automated overview of job runtimes, average runtime, success rate etc. by creating a dashboard in Tableau.
For this i need to get all jobs. Here i’ve used an Orhestrator HTTP Request for getting all jobs:
However, it has a limit of 1000. This is fine, but i am unable to define from what date i want it to get jobs, so it just takes from first run job + 999 jobs ahead. This means i get jobs run in 2020 untill 2021. I would like to get everything, so i’m looking for a way to specify my HTTP request, so that i can run in through multiple times to get all jobs ever started.
Anyone who can guide me towards a solution?