I am using SQL Server 2000 with Service Pack 4 installed, which I have
several scheduled Agent Jobs running which are failing to complete.
The two jobs run under a "sa" account which has all the appropriate Security
Privileges set (this account is used with various other jobs and
all run successfully). The jobs have to be cancelled as they should have
completed minutes but were still executing after several hours.

The DTS are fairly straightforward in that they get some data, it goes
through a data pump and then produces an excel report.

When the job is run manually (i.e. using the Agent Job start job) under the
same account/privileges, it is successful. One of the things
I have tried was to rebuild the DTS from scratch as we have have had on
occassions DTS's becoming corrupt, rescheduled it under a new
job, again they still did not execute to completion.


Many Thanks
Paul Myers