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?

[Kaniz]

Hi @ yatharth29! My name is Kaniz, and I'm the technical moderator here. Great to meet you, and thanks for your question! Let's see if your peers in the community have an answer to your question first. Or else I will get back to you soon. Thanks.

[yatharth29]

Hi @Kaniz Fatma​ . Sure, Thanks!

[Kaniz]

Hi @yatharth29,

Email alerts are sent in case of job failure, success, or timeout. You can set alerts up for job start, job success, and job failure (including skipped jobs), providing multiple comma-separated email addresses for each alert type. You can also opt-out of alerts for skipped job runs.

You can definitely schedule your job by entering the specific details here:- 

You can set email alerts accordingly too:-

 

You'll find the detailed instructions here in this link as well:-

https://docs.databricks.com/jobs.html

[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.