topic Re: Pulling list of running jobs using JOBS API 2.1 in Data Engineering

Pulling list of running jobs using JOBS API 2.1

celerity12 — Sun, 03 Apr 2022 19:45:20 GMT

I need to find out all jobs which are currently running and not get other jobs

The below command fetches all the jobs

curl --location --request GET 'https://xxxxxx.gcp.databricks.com/api/2.1/jobs/list?active_only=true&expand_tasks=true&run_type=JOB_RUN&completed_only=false&verbose=TRUE& offset=0' \

--header 'Authorization: Bearer xxxxxxxx'

active_only=true doesn't seem to work. Any help is appreciated

Re: Pulling list of running jobs using JOBS API 2.1

AmanSehgal — Mon, 04 Apr 2022 01:47:47 GMT

Work around -

You can add a filter for start_time and end_time to get jobs that were executed after a specific date (eg. T-1 day) to current time. And once you get the response, parse the JSON output to filter out jobs that don't have end time (implying that they're still running).

Re: Pulling list of running jobs using JOBS API 2.1

Hubert-Dudek — Mon, 04 Apr 2022 09:12:03 GMT

Strange. I've tested your curl with Azure databricks, and everything worked perfectly. What distribution are you using?

Re: Pulling list of running jobs using JOBS API 2.1

celerity12 — Mon, 04 Apr 2022 19:01:33 GMT

Thanks @Hubert Dudek I am working with GCP Databricks. I do not see any start time and end time

Re: Pulling list of running jobs using JOBS API 2.1

Atanu — Fri, 13 May 2022 05:55:59 GMT

@Sumit Rohatgi can you try with limit and see if that works. are you still not getting it worked?Please let me know if still this is not listing. Thanks. also, just try running https://xxxxxx.gcp.databricks.com/api/2.1/jobs/list?active_only=true and see if the output.

Re: Pulling list of running jobs using JOBS API 2.1

jose_gonzalez — Tue, 07 Jun 2022 18:10:49 GMT

Hi @Sumit Rohatgi,

Just a friendly follow-up. Did Atanu's response help you? please let us know if you still need help.

Re: Pulling list of running jobs using JOBS API 2.1

User16764241763 — Sat, 11 Jun 2022 08:31:45 GMT

Hi @Sumit Rohatgi

It seems like active_only=true only applies to jobs/runs/list API and not to jobs/list.

Can you please try the jobs/runs/list API?

Re: Pulling list of running jobs using JOBS API 2.1

jose_gonzalez — Mon, 25 Jul 2022 18:42:57 GMT

HHi @Sumit Rohatgi,

Just a friendly follow-up. Did any of the responses help you to resolve your question? if it did, please mark it as best. Otherwise, please let us know if you still need help.