dbms_scheduler 执行shell script

jnrjian

已于 2023-08-01 16:23:17 修改

阅读量275

点赞数

文章标签： oracle

于 2023-07-31 16:29:18 首次发布

本文链接：https://blog.csdn.net/jnrjian/article/details/132025163

版权

A simple dummy example to validate this:

rm /tmp/mylog_*.log
echo '#!/bin/ksh' > /tmp/test.sh
echo 'DATE=`date +%Y%m%d`' >> /tmp/test.sh
echo 'echo "this is a test " > /tmp/mylog_$DATE.log' >> /tmp/test.sh
sqlplus /nolog << EOF

connect / as sysdba
exec dbms_scheduler.drop_job('MY_JOB');
exec dbms_scheduler.drop_credential('MY_CRED');
exec dbms_scheduler.create_credential('MY_CRED','oracle','oracle1');

begin
dbms_scheduler.create_job(
job_name => 'MY_JOB',
job_type => 'EXECUTABLE',
job_action => '/tmp/test.sh',
auto_drop => FALSE,
enabled => false,
comments => 'Run shell-script');
end;
/
exec dbms_scheduler.Set_Attribute('MY_JOB', 'credential_name', 'MY_CRED' );
exec dbms_scheduler.enable('MY_JOB');
-- failure with wrong credentials
exec dbms_scheduler.run_job('MY_JOB');
-- fixing the credentials
exec DBMS_SCHEDULER.SET_ATTRIBUTE(name=>'MY_CRED',attribute=>'password',value=>'oracle');
-- run successfully
exec dbms_scheduler.run_job('MY_JOB');

-----？？错了也能执行，只能重建不能set

SQL> exec DBMS_SCHEDULER.SET_ATTRIBUTE(name=>'MY_CRED',attribute=>'passfword',value=>'oracle');
begin DBMS_SCHEDULER.SET_ATTRIBUTE(name=>'MY_CRED',attribute=>'passfword',value=>'oracle'); end;

ORA-27469: PASSFWORD is not a valid credential attribute
ORA-06512: at "SYS.DBMS_ISCHED", line 3246
ORA-06512: at "SYS.DBMS_SCHEDULER", line 3150
ORA-06512: at line 1