DTS schedule

[SQLScholar]

Hey all,

We are currently having a problem with DTS. Firstly some packages dont seem to run to schedule, whats the easiest way to find out why?

Secondly - if you click schedule, and set it. How can you change it? For some reason, if you click schedule again, it is back to default.

TIA

Dan

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!
----------------------------------------
No D, just plank - and its not my fault

 

[SQLDenis]

Part 1 got to SQL Agent/Jobs
If the job is 'red' an error occured
Right click on the job-->view job history, click on show step details(for mult step jobs)
click on the step and look in the errors/messages part of the dialog box

For the second part
go to the job (same name as the DTS package) click on the schedules tab-->edit-->change

http://sqlservercode.blogspot.com/