dts scheduler 1

[sixtoedsloth]

Hi,

i have a dts package which i can execute and it works
when i try to schedule it, i change the schedule and press ok. but when i go back into the schedule, its back at defaults.

anyone know whats going on?

 

[JayKusch]

Have you check to see if the associated job that is created by scheduling the DTS package is there and has the correct time set that you are desiring?

Thanks

J. Kusch

 

[sixtoedsloth]

Hi, JayKusch

no, how would i do that? where is it stored?

 

[JayKusch]

In Enterprise Manager (EM) you would drill down to

Management..SQL Server Agent..Jobs

Thanks

J. Kusch

 

[sixtoedsloth]

Ah I see!

they are all there, they are probably failing because
there are now lots of them. all the same!! ;->

thankyou for your prompt response

a star for you.

Russ