Hi Everyone,

I have 5 DTS scheduled tasks packages which grab different files throughout
the day and import into the DB. What I can’t stop from happening is the
scheduled tasks un-enable themselves, so the next morning I have to select
the schedule task tab for each one and tick the enable box again. I have
rebuilt the DTS packages several times, but can’t stop this from happening.
All the other scheduled tasks packages I have created stay enabled.

Does anyone know why this occurs and any possible solutions?

Thanks,

Nik

Make sure the job isn't set to run once and make sure it
hasn't reached the end of the scheduled date/time.

But....what version of SQL Server and what Service Pack?
Also, check your SQL Server Agent log for any messages
related to scheduling. There was the following issue fixed
by service packs - which sounds like what you could be
running into:
FIX: SQLAgent Job with Recurring Schedule is Disabled Upon
Completion of the Schedule for the Day
http://support.microsoft.com/?id=295378

-Sue

On Wed, 8 Dec 2004 07:57:04 -0800, Nik
<Nik (AT) discussions (DOT) microsoft.com> wrote:

Thanks Sue,

We had put the updated service pack on all the SQL boxes except this one.

Nik