Uso DBMS_SCHEDULER para executar script unix

CREATE A PROGRAM
begin
dbms_scheduler.create_program
(
program_name => ‘UPDATE_VERITAS’,
program_type => ‘EXECUTABLE’,
program_action => ‘/opt/oracle/scripts/blade08/update_veritas.sh’,
enabled => TRUE,
comments => ‘Check the Time’
);
end;
/
 CREATE A SCHEDULE

begin
dbms_scheduler.create_schedule
(
schedule_name => ‘EVERY_6_HOURS’,
repeat_interval => ‘FREQ=HOURLY; INTERVAL=6?,
comments => ‘Every 6 Hours’
);
end;
/

CREATE A JOB

begin
dbms_scheduler.create_job
(
job_name => ‘RUN_UPDATE_VERITAS’,
program_name => ‘UPDATE_VERITAS’,
schedule_name => ‘EVERY_6_HOURS’,
comments => ‘Run the program UPDATE_VERITAS every 6 Hours’,
enabled => TRUE
);
end;
/

RUN THE JOB MANUALLY
exec dbms_scheduler.run_job(’RUN_UPDATE_VERITAS’);

Check the job run status and other details     

select log_id, log_date, job_name, status, error#, additional_info
 from dba_scheduler_job_run_details
where job_name =’RUN_UPDATE_VERITAS’;