Unanswered: DTS Job Not Erroring, But Not Working Properly
I have a total of about 60 databases, all of which have a DTS package associated with them to copy data from one database to another on the same server. These jobs are all scheduled to run at 01:00 every Saturday morning.
My problem is that although the jobs run fine, and don't error, some jobs will simply not copy either tblInventory or tblDefects (tables in the source database) for no apparent reason. This is apparently random, and will happen with whatever job it feels like. Sometimes I only have 1 database with this problem, sometimes it could be as high as 20.
I've looked into this as much as I can, but must admit that I am now stumped. Does anyone have any ideas?