dear all,
saya menjalankan create_job menggunakan dbms_scheduler melalui procedure dengan
syntax seperti ini :
CREATE OR REPLACE procedure RunScript (jobName in varchar2, cmd in varchar2) as
Begin
DBMS_SCHEDULER.CREATE_JOB(
job_name=>jobName,
job_type=>'EXECUTABLE',
job_action=> cmd,
enabled=>true,
auto_drop=>true);
end;
saya jalankan
begin
runscript('test20','test.sh');
end;
hasilnya error:
ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 99
ORA-06512: at "SYS.DBMS_SCHEDULER", line 262
ORA-06512: at "DM.RUNSCRIPT", line 3
ORA-06512: at line 1
tapi kalau saya jalankan langsung seperti ini
Begin
DBMS_SCHEDULER.CREATE_JOB(
job_name=>'test20',
job_type=>'EXECUTABLE',
job_action=> 'test.sh',
enabled=>true,
auto_drop=>true);
end;
hasilnya successfull..
fenomena apa gerangan??
