When you view the schedule through the package, it displays
the default times not the scheduled times.
To view the "real" schedule, you need to look at the job
that was created for the package..
See the following for more info:
BUG: DTS: Default Scheduling Information Displayed
http://support.microsoft.com/?id=221480 -Sue
On Tue, 13 Apr 2004 19:57:06 -0400, "Tom"
[quoted text, click to view] <bingoman@stny.rr.com> wrote:
>I have serveral DTS packages on an sql 2000 server used to import data from
>text files downloaded from a mainframe database. The packages have been
>running since November 2003 with no major problems until today. The
>packages failed to run at the times scheduled (6 am Mon-Fri). When looking
>at the scheduled times, they had been reset to 12:00 AM once a week. Any
>reaon why would be aprreciated.
>
I have serveral DTS packages on an sql 2000 server used to import data from
text files downloaded from a mainframe database. The packages have been
running since November 2003 with no major problems until today. The
packages failed to run at the times scheduled (6 am Mon-Fri). When looking
at the scheduled times, they had been reset to 12:00 AM once a week. Any
reaon why would be aprreciated.