使用dbms_scheduler调用shell脚本

--1,创建program
begin
  dbms_scheduler.create_program(program_name   => 'lcy_test_prog',
                                program_type   => 'EXECUTABLE',
                                program_action => '/lcytest/File_test.sh',
                                enabled        => true,
                                comments       => 'oracle database rman level 0 backup');
end;

--2,创建schedule 每天凌晨运行一次
begin
  dbms_scheduler.create_schedule(schedule_name   => 'lcy_test_sche',
                                 repeat_interval => 'freq=daily; byhour=0; byminute=0; bysecond=0;',
                                 comments        => 'oracle database rman level 0 backup schedule 1');
end;

--3,创建job,此处若提示权限问题，则需要grant 
--grant CREATE EXTERNAL JO