To run a batch job in oracle. You want to use nohup, redirect the nohup.log etc.
nohup sqlplus [user]/[pwd] @[script] / -print > [logfile] &
note that the "-print >" is not to be changed
The spooling doesn't work due to the fact that the spool buffer seems to be flushed at the end of the script
Monday, 26 November 2007
Subscribe to:
Posts (Atom)