DTS schedule not kicking in

[IanMackay123]

Hi, I have a bunch of repeating DTS packages in SQL server 2000 that I have set to run once every day.

When created they run fine on immediate execution, but they do not repeat the execution after this, even though when I right click on them and select "Schedule" the supposed schedule shows up.

Any ideas why the automated schedule is not running would be very much appreciated!

Thanks,

Ian

 

[AlexCuse]

By schedule, you mean you scheduled them as a job right? And, is the job not running, or is it failing?

First thing to check for a problem like this is usually the permissions associated with the SQL Server Agent account (the one that runs the jobs).


[small]----signature below----[/small]
I don't do any programming whatsoever

Ignorance of certain subjects is a great part of wisdom

 

[Gragi]

As well make sure
MSSQLSERVERAGENT is automatic in services,
Sql Server Agent is running in the Taskbar.


Gragi