Stop and Resume a process
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.
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
But you may achieve this by using DBMS_SCHEDULER and scheduler windows.
Last edited by Thomasps; 05-31-2006 at 09:46 AM.
or you could put the unix process to sleep on sunday night and resume it Friday.
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.
Click Here to Expand Forum to Full Width