I have five DTS packages that are scheduled to run at varying times. Three
of them run once a day in the evening and two of them run every five
minutes all day long. The two that run every five minutes have been
causing a problem ever since I migrated from SBS 4.5 to SBS 2003. They
work correctly more than 99% of the time, but every once in a while they
hang. The Status column under Management\SQL Server Agent\Jobs shows
"Executing Job Step '1" and it will remain that way for days if I don't do
an "End Job". Once I end it, then they are back to working for a couple of
days, then they will hang again. I never had problems with the other three
until recently. Now every single time they hang with the status of
Executing... I can go into Data Transformation Services\Local Packages,
right click and "Execute Package" and that works fine. But if I right
click on the scheduled job and select "Start Job" then it hangs. No job
history is created when it hangs. I turned logging on and when I open the
log it shows two steps. The first is DTSStep_DTSExecuteSQLTask_1 and the
second is DTSStep_DTSDataPumpTask_1. They both have check marks. Run
Status for the first is a 4 and it has a start time and end time. Run
Status for the second is 0 and it has a start time but no end time. This
is the case for all of the jobs. It is obviously hanging on the data pump
task, but the daily jobs are exporting to text files while the nightly jobs
are importing from an AS/400. Has anybody seen anything similar to this
and maybe know of a solution?

Thank you,
Jeremy Olmstead