https://community.databricks.com/t5/data-engineering/how-can-i-extract-get-the-time-along-with-the-status-failed-or/m-p/11020#M6061 <P>Hi&nbsp;@Kaniz Fatma​&nbsp;,</P><P>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?</P><P></P><P>Thanks in advance.</P> Thu, 11 Nov 2021 14:11:55 GMT yatharth29 2021-11-11T14:11:55Z https://community.databricks.com/t5/data-engineering/how-can-i-extract-get-the-time-along-with-the-status-failed-or/m-p/11016#M6057 <P>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?</P> Thu, 11 Nov 2021 10:45:00 GMT https://community.databricks.com/t5/data-engineering/how-can-i-extract-get-the-time-along-with-the-status-failed-or/m-p/11016#M6057 yatharth29 2021-11-11T10:45:00Z https://community.databricks.com/t5/data-engineering/how-can-i-extract-get-the-time-along-with-the-status-failed-or/m-p/11018#M6059 <P>Hi @Kaniz Fatma​&nbsp;. Sure, Thanks!</P> Thu, 11 Nov 2021 11:44:35 GMT https://community.databricks.com/t5/data-engineering/how-can-i-extract-get-the-time-along-with-the-status-failed-or/m-p/11018#M6059 yatharth29 2021-11-11T11:44:35Z https://community.databricks.com/t5/data-engineering/how-can-i-extract-get-the-time-along-with-the-status-failed-or/m-p/11020#M6061 <P>Hi&nbsp;@Kaniz Fatma​&nbsp;,</P><P>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?</P><P></P><P>Thanks in advance.</P> Thu, 11 Nov 2021 14:11:55 GMT https://community.databricks.com/t5/data-engineering/how-can-i-extract-get-the-time-along-with-the-status-failed-or/m-p/11020#M6061 yatharth29 2021-11-11T14:11:55Z https://community.databricks.com/t5/data-engineering/how-can-i-extract-get-the-time-along-with-the-status-failed-or/m-p/11021#M6062 <P>Hi @Yatharth Kaushik​&nbsp; you can use the <A href="https://docs.databricks.com/dev-tools/api/latest/jobs.html#operation/JobsRunsList" alt="https://docs.databricks.com/dev-tools/api/latest/jobs.html#operation/JobsRunsList" target="_blank">JobsRunList API</A> to get all the information of the job run. You can write a code to extract the information that you need for the table.</P><P></P><P>The are multiple API's in the same doc that you can use to get information about the jobs and runs.</P> Wed, 17 Nov 2021 16:37:02 GMT https://community.databricks.com/t5/data-engineering/how-can-i-extract-get-the-time-along-with-the-status-failed-or/m-p/11021#M6062 Prabakar 2021-11-17T16:37:02Z