Post reply

DTS SCHEDULING TIME and DTS for Update

  • March 24, 2006 at 11:59 am

    #68305

    Hi everyone

    I have a DTS that I sheduled to run every minute. Does someone knows how I can schedule it to run like every 3 seconds.

    Other thing . My DTS is updating a table . When it is runnig and the table is open it gave me an error. How can I run the DTS while  the table that It updates is open ?

     

    Thank you very much

  • March 24, 2006 at 1:13 pm

    #628734

    You cannot schedule a job to run more often than 1 minute.  What are you trying to do that needs done every 3 seconds?

    What is the error message that you are getting?  When you say the table is 'open', what do you mean?  If there is a table lock on the table, no other processes can access the table for updates.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • March 24, 2006 at 6:29 pm

    #628763

    John

    Yes. It needs to be run every 3 seconds.

    The error message.

    I will do more test and send you the error message.

    Thanks

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

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