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]

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?

[yatharth29]

Hi @Kaniz Fatma​ . Sure, Thanks!

[yatharth29]

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.

[Prabakar]

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.