Hi All,

SQL Server 7
We have scheduled DTS jobs to run at specific intervals.

These DTS jobs runs fine sometimes and sometimes some DTS
jobs won't.
When we look at the status of these jobs from Enterprise
manager, we find either
a) DTS job is failed
or
b) DTS job status shows executing and will be never ending
and is more or less hung.

both the cases, DTS schedule will not be reset for the
next run so DTS job will never run again and we manually
run it to make it happen. Is there any way to solve it.
please help
TIA
Adil

What are the errors when it fails?
Does it only happen in Jobs ? i.e. not manually

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Adil" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi Allan,

Thanks for acknowledgement

Most of the time it hangs, when it fails it says failed at
step 1.

Regards
Adil

Enable logging in the package to a text file (Right Click white space |
Package properties)
In the job history you can expand the steps by a little checkbox in the
corner

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Adil" <anonymous (AT) discussions (DOT) microsoft.com> wrote