September 11, 2003 at 1:52 pm
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?
September 11, 2003 at 5:41 pm
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
September 12, 2003 at 7:59 am
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