Re: run an external OS script in Oracle 10g

From: Michele Campagni <michele.campagni_at_libero.it>
Date: Sat, 22 Apr 2006 21:25:32 +0200
Message-ID: <444a832d$0$29093$5fc30a8@news.tiscali.it>

sorry, I've make a mistake, I would to say:

>>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
>>/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 - 14:25:32 CDT