Post reply

DTS Schedule question

  • October 10, 2003 at 1:20 am

    #106634

    Hi,

    I have a DTS package under local that I want to schedule under SS7. WHen I left-click, schedule and OK it, then go back in, the schdule time has reverted to 12:00 AM again. I need the package to run once an hour.

    How do I fix this?

    Evyn

  • October 12, 2003 at 5:21 pm

    #477954

    When you say 'then go back in, ...', are you checking the scheduled job that was created when you click ok, or are you choosing schedule from the DTS package?

    If it is the latter, then you are effectively re-scheduling the package. You need to check the Scheduled Job which is located under Management->SQL Server Agent-> Jobs. It will have the same name as the DTS package.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply