This content has been marked as final. Show 3 replies
Shr12345 wrote:What do you mean by "remote"? Where do you want to execute the scripts?
Is there a way to execute remote shell scripts/perl script through APEX 4.1?
I use Application Express 4.1.1.00.23
Hi,1 person found this helpful
I use it this way:
There is used program definition, scheduler, job ...
-- Shell Script. BEGIN DBMS_SCHEDULER.create_program ( program_name => 'sync', program_type => 'EXECUTABLE', program_action => '/some_loc/some_dir/sh/sync.sh', number_of_arguments => 0, enabled => TRUE, comments => 'SH script where is link to another remote sh script #!/bin/sh ssh remote_user@host ./some_dir/bin/replicate.sh'); END; / -- Create the schedule. BEGIN DBMS_SCHEDULER.create_schedule ( schedule_name => 'sync_schedule', start_date => SYSTIMESTAMP, repeat_interval => 'freq=daily; byhour=18; byminute=0; bysecond=0', end_date => NULL, comments => 'Repeats daily on 18:00 - when somebody forgot to run it manualy'); END; / -- Job defined by an existing program and schedule. BEGIN DBMS_SCHEDULER.create_job ( job_name => 'sync_job_definition', program_name => 'sync', schedule_name => 'sync_schedule', enabled => TRUE, comments => 'Job defined by an existing sync program and schedule.'); END; /
I hope it will bring some help.
I will try this. jozef_SVK
Edited by: Shr12345 on Jan 3, 2013 9:51 PM