Issuing a background execute procedure command

[topstar]

Hi Folks,

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.

[agasimani]

Look for DBMS_JOB.

[adewri]

Hi

try using DBMS_JOB package :-)

Regards
Amar