Overview of running SSIS package from SSISDB

 Overview of running SSIS package from SSISDB

SELECT        

  start_time
, execution_id
, folder_name
, project_name
, package_name
, reference_id
, reference_type
, environment_folder_name
, environment_name
, project_lsn
, executed_as_sid
, executed_as_name
, se32bitruntime

, operation_type

, created_time

, object_type

, object_id

, status

, end_time

, caller_sid

, caller_name

, process_id

, stopped_by_sid

, stopped_by_name

, dump_id

, server_name

, machine_name

, worker_agent_id

, total_physical_memory_kb

, available_physical_memory_kb

, total_page_file_kb

, available_page_file_kb

, cpu_count

, executed_count

FROM           [SSISDB].[catalog].[executions]

WHERE        (end_time IS NULL)

ORDER BY start_time