How to get the last time ( previous ) databricks job run time?

[sgannavaram]

How to get the last databricks job run time? I have a requirement where i need to pass last job runtime as an argument in SQL and this SQL get the records from snowflake database based on this timestamp.  

[Hubert-Dudek · Accepted solution]

You can get last job run time using Jobs API: https://docs.databricks.com/dev-tools/api/latest/jobs.html#operation/JobsRunsList

https://<databricks-instance>/api/2.1/jobs/runs/list

https://<databricks-instance>/api/2.1/jobs/runs/get

[sgannavaram]

Thank you very much for your response Hubert. How can we call these api in databricks code? it would be really help if you have any sample code.

[RKNutalapati]

@Srinivas Gannavaram​ : Sample python pseudocode for jobs API. Hope this helps you to build your Logic

import requests
import json
 
databricks_instance ="<databricks-instances>"
url_list = f"{databricks_instance}/api/2.1/jobs/runs/get?run_id=<Your Job RunID>"
 
headers = {
 'Authorization': 'Bearer <databricks-access-token>',
 'Content-Type': 'application/json'
}
 
response = requests.request("GET", url_list, headers=headers).json()
print(response)
print(response['job_id'])
print(response['start_time'])
print(response['end_time'])

[sgannavaram]

Thank you so much. I will test it.

[Anonymous]

@Srinivas Gannavaram​ - Please let us know how it goes!

[Anonymous]

Hey there @Srinivas Gannavaram​ 

Hope you are well. Just wanted to see if you were able to find an answer to your question and would you like to mark an answer as best? It would be really helpful for the other members.

Cheers!