Stop and restart DTS schedule

  • I have a scheduled DTS package running on SQL Server 2000. Is it possible to stop this schedule and then restart it all in a stored procedure?

  • Sure. You will have to run an update against the sysjobschedule table (I think that is the table name - at Oracle training and I don't have SQL Server in front of me) and set the enabled flag appropriately.

    Hopefully that will meet your needs.

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • Thnks for the reply! However, I have decided to take a different route. I read somewhere on this site where somebody suggested making a enable bit in a table. So, in my VB I am going to check to see if the bit is 0 then I will run the package, if it is one then I will exit the package. That way I can use it anywhere in my system to stop large processes that might conflict.

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

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