https://community.fabric.microsoft.com/t5/Pipelines/How-to-get-the-Microsoft-Fabric-pipeline-run-time-in-to-the/m-p/4168484#M5491 <P>Run time = Last refresh date and time I want.</P> Mon, 23 Sep 2024 23:26:16 GMT kasun_rumesh 2024-09-23T23:26:16Z https://community.fabric.microsoft.com/t5/Pipelines/How-to-get-the-Microsoft-Fabric-pipeline-run-time-in-to-the/m-p/4167043#M5474 <P>I want to get the Microsoft Fabric pipeline run time in to the Fabric Warehouse Table.</P> Mon, 23 Sep 2024 10:49:30 GMT https://community.fabric.microsoft.com/t5/Pipelines/How-to-get-the-Microsoft-Fabric-pipeline-run-time-in-to-the/m-p/4167043#M5474 kasun_rumesh 2024-09-23T10:49:30Z https://community.fabric.microsoft.com/t5/Pipelines/How-to-get-the-Microsoft-Fabric-pipeline-run-time-in-to-the/m-p/4168374#M5486 <P>have you try to use a store procedure (custom self logging what you want, pipeline name, start run timestamp, etc.) as the first step of your pipeline? There may be a few seconds delay for the real pipeline run start time and the time of executing the SP. Not sure if that could fit your needs 100%.</P> Mon, 23 Sep 2024 21:25:41 GMT https://community.fabric.microsoft.com/t5/Pipelines/How-to-get-the-Microsoft-Fabric-pipeline-run-time-in-to-the/m-p/4168374#M5486 Houston-ho 2024-09-23T21:25:41Z https://community.fabric.microsoft.com/t5/Pipelines/How-to-get-the-Microsoft-Fabric-pipeline-run-time-in-to-the/m-p/4168394#M5489 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="317253" data-lia-user-login="kasun_rumesh" class="lia-mention lia-mention-user">kasun_rumesh</a>,</P><P>&nbsp;</P><P>Another option is to use the MS Fabric API to retrieve the start and end time of a job and calculate the run time. You could look into this API:&nbsp;<A href="https://learn.microsoft.com/en-us/rest/api/fabric/core/job-scheduler/get-item-job-instance?tabs=HTTP" target="_blank">https://learn.microsoft.com/en-us/rest/api/fabric/core/job-scheduler/get-item-job-instance?tabs=HTTP</A></P> Mon, 23 Sep 2024 21:46:36 GMT https://community.fabric.microsoft.com/t5/Pipelines/How-to-get-the-Microsoft-Fabric-pipeline-run-time-in-to-the/m-p/4168394#M5489 FabianSchut 2024-09-23T21:46:36Z https://community.fabric.microsoft.com/t5/Pipelines/How-to-get-the-Microsoft-Fabric-pipeline-run-time-in-to-the/m-p/4168482#M5490 <P>Run time = Last refresh date and time I want.</P> Mon, 23 Sep 2024 23:25:52 GMT https://community.fabric.microsoft.com/t5/Pipelines/How-to-get-the-Microsoft-Fabric-pipeline-run-time-in-to-the/m-p/4168482#M5490 kasun_rumesh 2024-09-23T23:25:52Z https://community.fabric.microsoft.com/t5/Pipelines/How-to-get-the-Microsoft-Fabric-pipeline-run-time-in-to-the/m-p/4168484#M5491 <P>Run time = Last refresh date and time I want.</P> Mon, 23 Sep 2024 23:26:16 GMT https://community.fabric.microsoft.com/t5/Pipelines/How-to-get-the-Microsoft-Fabric-pipeline-run-time-in-to-the/m-p/4168484#M5491 kasun_rumesh 2024-09-23T23:26:16Z https://community.fabric.microsoft.com/t5/Pipelines/How-to-get-the-Microsoft-Fabric-pipeline-run-time-in-to-the/m-p/4173095#M5524 <P>Please try custom logging by adding some of the DB objects(like tables procedures) to add the data from pipeline. You can use SP activities at the beginning and end of the pipelines and also make use of system variables like runid, pipelinename..etc.</P> Wed, 25 Sep 2024 07:10:30 GMT https://community.fabric.microsoft.com/t5/Pipelines/How-to-get-the-Microsoft-Fabric-pipeline-run-time-in-to-the/m-p/4173095#M5524 purushotham15 2024-09-25T07:10:30Z