topic Re: GET /api/2.2/jobs/list Ordering in Data Engineering

GET /api/2.2/jobs/list Ordering

AlexMc — Thu, 24 Apr 2025 16:59:26 GMT

Hi there!

I am calling the job list API (via the Python SDK):

GET /api/2.2/jobs/list

docs.databricks.com/api/workspace/jobs/list

Does anyone know what ordering is applied / calculated for the list of jobs?
Is it consistent or random?
Is it by creation time?

Thanks,
Alex

Re: GET /api/2.2/jobs/list Ordering

Louis_Frolio — Thu, 24 Apr 2025 17:59:12 GMT

The API documentation does not explicitly specify the order in which jobs are returned. Anecdotal evidence suggests that the default ordering is descending by creation time. Additionally, such ordering seems to remain consistent across API calls unless altered by pagination or filtering.

To verify this, I also reviewed internal (non-public facing) documentation, which states:
"The response from the Databricks Jobs API /api/2.2/jobs/list does not explicitly define the ordering of jobs in the returned list within the provided documentation. There is no confirmed indication in the referenced materials whether jobs are ordered consistently or by specific fields such as creation time. Hence, it is likely that the ordering could be either random or implementation-dependent."

I hope this information proves helpful.

Best regards,
Louis

Re: GET /api/2.2/jobs/list Ordering

AlexMc — Fri, 25 Apr 2025 06:52:22 GMT

Hi Louis,

Thanks very much for the timely and helpful response!

I had a follow up question, if I may.
With the tasks list in the jobs, is that ordered in any particular way eg. creation time etc

Kind regards,
Alex

Re: GET /api/2.2/jobs/list Ordering

RiyazAliM — Fri, 25 Apr 2025 07:37:58 GMT

Hey @AlexMc
Per my experience with Rest APIs, the job or task list would be random. I couldn't see if there's any pattern or sorting by runtime or anything.

Thanks,

Re: GET /api/2.2/jobs/list Ordering

Louis_Frolio — Fri, 25 Apr 2025 15:29:28 GMT

I suspect that if the jobs are random then the tasks within a job will be random too. Louis

Re: GET /api/2.2/jobs/list Ordering

AlexMc — Fri, 25 Apr 2025 20:42:57 GMT

Thanks both - this was very helpful!

Re: GET /api/2.2/jobs/list Ordering

Louis_Frolio — Fri, 25 Apr 2025 21:41:40 GMT

If you have a chance pluse "like" and if you are satisfied accept this as a solution. Cheers, Louis.