I have scheduled jobs that execute DTSs with duration:"no
end date".
However, one week ago they all stopped running and they
don't run daily as scheduled at all. I have tried
rescheduling but it doesn't work.
Can you help? Thanks.

Difficult to troubleshoot without being there.

1. Make Sure the job is enabled
2. Make sure the schedule is enabled
3. Make sure SQL Server Agent is running
4. Check the logs (Agent and SQL Server) for errors.


--
--

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


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