SSIS DB Abfrage Laufzeit

SELECT TOP 10 [statistics_id]

      ,[execution_id]

      ,[executable_id]

      ,[execution_path]

      ,[start_time]

      ,[end_time]

      ,[execution_duration]

 ,[execution_duration]/60000 As Delta

      ,[execution_result]

      ,[execution_value]

  FROM [SSISDB].[catalog].[executable_statistics]

  where year(start_time) = 2023

 — and execution_path like ‘%orderitem%’

 and [execution_path] like ‘%ShopDB%’

 and [execution_path] like ‘%df%’

 and year (start_time) = 2023 and month (start_time) = 8 and day(start_time)=11

— =’Staging_ShopDBSC_G_AlleSC_T_2_parallel Load Order Itemstable orderItemsdf_orderItems’

  order by execution_duration desc