SSIS Active operations

 Just in case I forget about it again:

Stop 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

, use32bitruntime

, 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

EXEC [SSISDB].[catalog].stop_operation  @operation_id =54247

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