Re: How to start a Stored Procedure directly from Unix shell skript ?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 11 Mar 2003 21:34:00 -0000
Message-ID: <3e6e61ab$2_1@mk-nntp-1.news.uk.worldonline.com>

"NorwoodThree" <norwoodthree_at_my-deja.com> wrote in message news:ba03e2c.0303111125.46599b00_at_posting.google.com...
> The best practice approach is to create a dbms_job.
>
> However, if you absolutely must use a UNIX script
<snip>

Bingo! Norwood Three has hit the nail on the head.

If this 'job' is something which can be run in the database while the instance is up, use a database job.

OTOH, if it's something which must be run from the OS, like an exp or cold backup; cron it.

Warning: I do NOT want to see anyone anyone cron-ing stats gathering!

Regards,
Paul Received on Tue Mar 11 2003 - 15:34:00 CST