I have a DTS that I am trying to schedule for 07:00:00. However after I set
the schedule (using enterprise manager), if I go back in and look, the time
is reset to 00:00:00 ??

I tried setting it and not going back in and checking whether it had stuck,
hoping it was some display glitch, but the job dutifully started at 00:00:00

Anybody else had this problem?

Nigel Ainscoe
SQL2000 (8.00.760 (SP3)) running on Win2kServer

You could just be running into a known issue. After you have
scheduled the package, check the schedule through the job
under SQL Server Agent instead of through the package. There
is a problem where when checking the schedule through the
package, it will just always shows the default date/time but
this is just a display issue. The schedule will be correct
for the job itself. My guess is that when you checked the
schedule and the default was displayed, you may have saved
that.
The following article documents the issue:
BUG: DTS: Default Scheduling Information Displayed
http://support.microsoft.com/?id=221480

-Sue

On Wed, 19 Nov 2003 10:44:31 +0100, "NigelA"
<nigel.ainscoe (AT) somewhere (DOT) com> wrote:

Yes, that's the one. Checking SQL Agent shows it to be scheduled correctly.

Another behaviour I didn't expect was that several attempts to schedule the
job have created several instances of the scheduled job, when I only wanted
one! I suppose it makes sense if one wanted to several the same job at a
number of irregular intervals.

Thanks
Nigel Ainscoe

"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote