DTS Scheduling | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Scheduling

We 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.
Rushendra
Have you tried using sp_update_jobschedule from QA.
What is the problem is that new time not affected or task is not executed. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Where are you trying to change the schedule from? EM or QA? Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

Moved to DTS forum. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

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
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |