Stop and Resume a process
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Stop and Resume a process

  1. #1
    Join Date
    May 2006
    Posts
    1

    Stop and Resume a process

    Hi,
    I am going to call a sql script from unix box in one weekend.
    And i want to stop it monday morning and resume the same in the next week end.

    The script should continue from where it stops and should not restart once again the process.

    (The script is to update a table which contains millions of records.)

    Is there any way to do like this?
    Can any pls tell me the way that i can proceed.

    Thanks,
    Adhi..

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    well you cant restart a script if you have killed it, you will have to code it into the query to only change the rows you want

  3. #3
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    But you may achieve this by using DBMS_SCHEDULER and scheduler windows.

    http://download-uk.oracle.com/docs/c.../schedover.htm
    Last edited by Thomasps; 05-31-2006 at 10:46 AM.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    or you could put the unix process to sleep on sunday night and resume it Friday.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Apr 2006
    Posts
    377
    You are talking about updating a HUGE table and then "pausing" the process for a week?

    Do you plan on doing a COMMIT during this process? Otherwise, you'll have issues with UNDO with this transaction.

    I honestly don't think this is the best way to do this. As davey23uk mentioned, you should do the update in chunks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width