SQL Server Performance

DTS Scheduling

Discussion in 'SQL Server DTS-Related Questions' started by rushmada, Sep 17, 2003.

  1. rushmada New Member

    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
  2. satya Moderator

    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
  3. gaurav_bindlish New Member

    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
  4. satya Moderator

    Moved to DTS forum.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  5. Jon M Member

    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

Share This Page