I experienced this issue a few weeks back. Turns out I was doing a large file copy in windows and it was depleting sql memory. Turns out this bug 'Runaway...

Ok, other than transactional replication what other requirements are there for MSDTC and the SQL Agent.

I was experiencing the same problem. DTS scheduled job failed, but runs fine from the EM. I was copying data from an Oracle database. Once my tnsnames file was correct...