I have a similar problem - killed processes still rolling back more than a day later - but a linked MySQL server is involved. Some of the processes that are "stuck" are just Select queries, so I wouldn't think there would be anything to rollback (for example: select * from openquery([MYSQL-WARRANTS],'select * from warranttab'). Kill with statusonly shows that it is 0% complete with 0 seconds remaining. After waiting a day, we rebooted the MySQL server hoping the process might just error out, but it still shows Running and Killed/Rollback. We tried stopping and starting the DTC. Does anyone know of any other way to cancel these processes other than stopping and starting the SQL server and hoping they end?
I also have same problem. My job pull data from teradata. It was running for last 3 days so i killed it 4th day, however now from last 2 days its in recovery. I had disabled daily schedule of job. Dontknow if restart of services will fix it.