Re: How I run a shell script from the scheduler on 10.2.0.2.0 ?

On 9/7/07, Owen Smith <owensmith99_at_gmail.com> wrote:
>
> I'd like to run a shell script from the Scheduler in my 10g database.
> Right now it is a simple shell script.
> Eventually it will wrap RMAN commands to back up my DB.
>
> I wrote a simple pl/sql script to create a job:
>
> -- cr_job10.sql
>
> The scheduler, though, errors out with an error which I see in a trace
> file:
>

*** 2007-09-06 17:33:00.175
> ORA-12012: error on auto execute of job 53267
> ORA-27369: job of type EXECUTABLE failed with exit code: 274662

Running external jobs from dbms_scheduler is much like running jobs from cron:
You must explicitly set the environment, as no environment is inherited.

See ML Notes *387451.1 and **389685.1.*

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l