hi!
I post this message several weeks ago and was not
successful to any findings.
DTS scheduled job used to run in less than 2 mins, is now
running in 15-30mins. Sometimes even 1 hr. I have no
problem when it is being run manually. But under
scheduled job, it is extremely slow. The job transfer data
from Sybase server to SQL 2000 server.

When i compared with my test server and the production
server, there is a difference in the drivers being used.
The slow down starts overnight when the box was replaced
with the motherboard. Here is the comparison:

Sybase Driver: SYODBASE.DLL
TEST (version 3.50.00.01, 20/09/02)
PRD (version 3.50.00.10, 29/09/03)

SQL Driver: SQLSRV32.DLL
Test (version 2000.81.7713.0,13/07/2001)
PRD (version 2000.81.9031.38,11/03/2003)

PRODUCT VERSION OF SQL
TEST (version 8.00.534 SP2)
PRD (version 8.00.760 SP3)

ODBC DRIVERS
TEST (version 3.520.7713.0)
PRD (version 3.520.9030.0)

I wonder if the differences in the driver version are the
reasons for the slowdown of the scheduled jobs.
Anyone has any idea?

Rgds.