Heh fair question, yes. I have an issue where a bunch of machines get trapped with queued up DTS jobs. Only way to break out of it is to restart the SMS Agent host on them (clears out the queue). I’m just wondering what causes it to Queue- I assume that a client has issues with reaching the DP intermittently, but there should be a recovery that happens when it can later contact the DP… these guys will go weeks without contact if unchecked.
From: [email protected] [mailto:[email protected]] On Behalf Of Dwayne Allen Sent: Wednesday, August 27, 2014 3:00 PM To: [email protected] Subject: Re: [mssms] Queued DTS Jobs Dumb question. IS your DP online? ----- Dwayne Allen [email protected]<mailto:[email protected]> (479) 310-0027 On Wed, Aug 27, 2014 at 3:41 PM, Jim Walker <[email protected]<mailto:[email protected]>> wrote: Hey folks, Any idea why DataTransferService might be indefinitely queuing up jobs? Ex: DTSJob {0ECC0FD1-96BE-43FC-9CA2-0E32019D3C09} in state 'Queued'.
