run an external OS script in Oracle 10g

From: Michele Campagni <michele.campagni_at_libero.it>
Date: Sat, 22 Apr 2006 17:40:44 +0200
Message-ID: <444a4e7d$0$29099$5fc30a8@news.tiscali.it>

I've difficult in executing an external OS script like this: vmstat.sh: "/usr/bin/vmstat >> /tmp/vmstat.LST" which have this permission:
-rwxr-xr-x 1 oracle other 47 Apr 3 05:13
/export/home/oracle/vmstat.sh

I try with this:

BEGIN

  dbms_scheduler.create_job(job_name        => 'myjob',
                            job_type        => 'executable',
                            job_action      => '/oracle/vmstat.sh',
                            enabled         => TRUE,
                            auto_drop       => TRUE);

END;
/

but oracle responds:
SQL> exec dbms_scheduler.run_job('VMSTAT_JOB'); BEGIN dbms_scheduler.run_job('VMSTAT_JOB'); END;

*
ERROR at line 1:

ORA-27369: job of type EXECUTABLE failed with exit code: Not owner
ORA-06512: at "SYS.DBMS_ISCHED", line 150
ORA-06512: at "SYS.DBMS_SCHEDULER", line 441
ORA-06512: at line 1

I'm using Solaris 10/Sparc and Oracle 10g. what's the problem?
thanks Received on Sat Apr 22 2006 - 10:40:44 CDT