I created a simple package that just doesn't want to run regularly.

It's simply an FTP download and overwriting a single file in a directory.

I scheduled it to run every night at a certain time but it is not doing so.

When I go back into the scheduling, I see that the default time is there,
not the time I scheduled it for.

Also, where is the log that tells me what happened? You'd think I could
right click the package and have that as an option.

SQL2000

With the DTS Job scheduled in SQL Server Agent, can you right-click on the
job and select "Start" or "Run" (I don't remember SQL 2000 UI)

If it runs OK as an Agent Job, then re-check the schedule. Try deleting it
and create a new schedule.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Rockitman" wrote:

With the DTS Job scheduled in SQL Server Agent, can you right-click on the
job and select "Start" or "Run" (I don't remember SQL 2000 UI)

If it runs OK as an Agent Job, then re-check the schedule. Try deleting it
and create a new schedule.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Rockitman" wrote:

With the DTS Job scheduled in SQL Server Agent, can you right-click on the
job and select "Start" or "Run" (I don't remember SQL 2000 UI)

If it runs OK as an Agent Job, then re-check the schedule. Try deleting it
and create a new schedule.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Rockitman" wrote:

With the DTS Job scheduled in SQL Server Agent, can you right-click on the
job and select "Start" or "Run" (I don't remember SQL 2000 UI)

If it runs OK as an Agent Job, then re-check the schedule. Try deleting it
and create a new schedule.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Rockitman" wrote:

With the DTS Job scheduled in SQL Server Agent, can you right-click on the
job and select "Start" or "Run" (I don't remember SQL 2000 UI)

If it runs OK as an Agent Job, then re-check the schedule. Try deleting it
and create a new schedule.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Rockitman" wrote:

With the DTS Job scheduled in SQL Server Agent, can you right-click on the
job and select "Start" or "Run" (I don't remember SQL 2000 UI)

If it runs OK as an Agent Job, then re-check the schedule. Try deleting it
and create a new schedule.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Rockitman" wrote:

With the DTS Job scheduled in SQL Server Agent, can you right-click on the
job and select "Start" or "Run" (I don't remember SQL 2000 UI)

If it runs OK as an Agent Job, then re-check the schedule. Try deleting it
and create a new schedule.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Rockitman" wrote:

With the DTS Job scheduled in SQL Server Agent, can you right-click on the
job and select "Start" or "Run" (I don't remember SQL 2000 UI)

If it runs OK as an Agent Job, then re-check the schedule. Try deleting it
and create a new schedule.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Rockitman" wrote:

Todd, I'm a bit confused to what you're saying.

If I right click the local package I created in Enterprise Manager, there
are options to Execute the package as well as Schedule the package. When I
select Execute package, it works fine. When I select Schedule package, I
then set my schedule and click OK. But it never runs when scheduled. When I
go back into Schedule package, my schedule is not there anymore either. Just
the default schedule which states run daily every day at midnight with no end
date. It doesn't run there either, only when I manually execute the
package.
What gives?

"Todd C" wrote: