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