How can I extract/get the time, along with the status (Failed or Succeeded) into a table for every time my Databricks job finishes running?

yatharth29
Databricks Partner

‎11-11-2021 02:45 AM

I want to get a mail notification at the end of each day for when my Databricks job has finished running and for that I need to extract the time of it's completion and it's status. How can I achieve that?

Labels:
0 Kudos

yatharth29
Databricks Partner

‎11-11-2021 03:44 AM

Hi @Kaniz Fatma​ . Sure, Thanks!

0 Kudos

yatharth29
Databricks Partner
In response to Retired_mod

‎11-11-2021 06:11 AM

Hi @Kaniz Fatma​ ,

Thanks but this not exactly what I wanted. I just want to get the time at which the job ended along with its status in a delta table on Databricks itself and this table will be used to create and send a custom mail which will contain other additional information. So the goal is to get the time of job completion first and then the mail will be created after getting the job related information. Is there any way to achieve that?

Thanks in advance.

0 Kudos

Prabakar
Databricks Employee
Databricks Employee

‎11-17-2021 08:37 AM

Hi @Yatharth Kaushik​  you can use the JobsRunList API to get all the information of the job run. You can write a code to extract the information that you need for the table.

The are multiple API's in the same doc that you can use to get information about the jobs and runs.

0 Kudos