Issuing a background execute procedure command
In Unix, I can start a background process by using nohup and &.
In Sql Plus I have a procedure which will take 2-3 days to run.
I wish to know if there is a safe way of issuing the execute procedure in the background and then coming out of my Sql Plus session, switch off my pc and go home and then check if this procedure has completed after 2-3 days, like over the weekend? If so how do I do this?
(I do not have Unix here so I cannot issue the background process, I have Win 95 running on my computer and the database is on a server running Unix)
Any help will be much appreciated.
Thanks in advance.
A farmer learns more from a bad harvest than a good one
try using DBMS_JOB package :-)
Click Here to Expand Forum to Full Width