Update:

The original diagnosis was incorrect. The job *does* report as running in msdb. The DTSRun.exe process is still running after the DTS package seems to have completed.

I used DTS package...

Well, the customer hasn't told me the problem has gone away, but they won't give me an update on it, either. Not sure what's up with that, but I will...

That makes sense! Thank you. I'll pass the info on to the customer and they can test the theory next time it happens (which will probably be tonight).

I'll let you...

*bump*

This one's not going away for me, and I still haven't found the solution. Anyone have an idea?

Thanks,

Jason

Thanks for the replies!

The problem is, indeed, missing indexes on the table sitting on the server that is misbehaving. I will be switching the pk distribution process back to that...

For me, after hours of work thinking it was related to Golden Gate replication, I realized it was probably a SQL Server issue, bounce the SQL Server service, and the...

I just went through this with an execute process task. I changed the timeout to zero in the properties. No more timeouts 🙂

It's confusing, because it looks like you need...

I may have found the problem and it seems to have nothing to do with SQL Server. I confirmed the ODBC driver for Red Brick is an old version, predating...

I ran into similar job problems when moving system DBs from one server to another (long story). The same problem happens if a server is renamed. Have you done anything...