Hi!,

I request all your help!. Nowadays, on a production server exists 14
jobs that runs everyday on different schedules.

Since last week, 4 of these 14 jobs are hanging, I mean, job starts
without any problem but never end, never refresh to suceeded status
even all tasks were finishied succesfully (I know this because I write
to a table with Hour, Procedure Name and Id), all steps are executed.

I tried:
* Recreating DTS using same table names, same structure and just
calling DTS different.
* Running DTS as package, structured storage, etc.(This was using
DTSrun utility)

Also, SQLAgent and SQLServer services are restarted as a part of a
backup plan for reading MDF files. I have tried many things but I have
abled to resolving this issue. Any help will be much appreciated.