SQL SERVER VERSION:Microsoft SQL Server 2014 (SP2-CU10-GDR) (KB4052725) - 12.0.5571.0 (X64)
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: )
OS version - WINDOWS SERVER 2012 R2 STANDARD
SSIS - SQL 2014 - Microsoft SQL Server 2014 (SP2-CU10-GDR) (KB4052725)
Last few months we are facing the issues 2 -3 times
We have observed that Jobs which are scheduled using T-SQL are getting completed successfully, issue is with SQL jobs which are configured by SSIS and those are getting halted after some time post re-starting the Integration service.
The SSIS Jobs will works for while and start to get hung and wont do anything -Anyone can tell me what could be the issue Why only the SSIS jobs hung and others are works fine?