Monday 26 November 2007

Nohup and sqlplus for long oracle batch jobs

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