SQL Server Performance Forum – Threads Archive
DTS SchedulingWe have created local package under data transformation services
which will port data from one server to another server and we have
scheduled the package by 1:00am and say ok.
After that if we want to change the job scheduling
time to different time system is not taking the new time. Ur views pl.
Have you tried using sp_update_jobschedule from QA.
What is the problem is that new time not affected or task is not executed. _________
Where are you trying to change the schedule from? EM or QA? Gaurav
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
Moved to DTS forum. _________
How are you changing the schedule? Because once you have successfully scheduled a DTS, a new Job is created. Try this:
From Enterprise Manager, select your SQL Server group then click on the Management folder to expand the items below it. From the SQL Server Agent->Jobs, you will be able to see all your jobs. Right click or double-click on specific Job. Then to change your schedule click on the Schedule tab. Jon M