Dear Everyone,

I've problem with my SQL Server 2000. I've several DTS which have
scheduled through SQL Server Job. All job successfully run, except 1
job. The job run very longer (62 hours). This problem occured since 6
days ago. It seems well before, with approximate finished in 6 minutes.

The strange thing : if I run these DTS (didn't through JOB), it runs
well, and will be finished in 2 - 6 minutes.

Has anybody help me? Why these job run longer than usually?

Thanks

Dear All,

I've solve the problem. JOB run in long time because there's an
application which called from DTS has error to initialize and show a
message box. The message box can close automatically, but waiting user
inteference. So while the message box not yet closed, job is being run.
If the message box closed, the job will be finished.

Thanks.

Yap Michael wrote: