Re: Background processes inside the database.
Posted in 2003
tophertheread@netscape.net (Topher TheRead) wrote in message news:<719e0031.0310080819.149b63ef@posting.google.com>...
> "Jack Parker" <vze2qjg5@verizon.net> dashed out a message saying:
> > You could always go for an intermediate step. Set a flag in a table, have
> > an OS process (cron scheduled or whatnot) check that table to see if it
> > should spawn the process you really want to run.
>
> Thanks, Jack, and sorry for the delay responding.
>
> For long and tedious reasons, not worth divulging, we are trying to
> eliminate the use of a daemon or polling process. I was hoping that
> 9.4 would make it unneccessary.
Why don't create a stored procedure and make a system call which
starts a background process?
create procedure system_call ()...
system ("/mypath/set_environment_script_and_start_whatever &");
...
end procedure;