How to run a Shell script from oracle DBMS_SCHEDULER

This is an example to show how to run a shell script from DBMS_SCHEDULER

Example :

#!/usr/bin/ksh

$ vi /tmp/try.sh
#!/usr/bin/ksh
ls >> /tmp/try.log


SQL> conn system/****
Connected.


SQL> BEGIN DBMS_SCHEDULER.CREATE_JOB
2 ( job_name=>'try2',
3 job_type=>'EXECUTABLE',
4 job_action=>'/tmp/try.sh',
5 enabled=>true,
6 auto_drop=>true);
7 END ;
8 /
PL/SQL procedure successfully completed.

SQL> select log_id, log_date, job_name, status, error#, additional_info2 from dba_scheduler_job_run_details3 where job_name ='Try2';

LOG_ID
----------
LOG_DATE
--------------------------------------------------------------------------- JOB_NAME STATUS ERROR#
------------------------------ ------------------------------ ----------
ADDITIONAL_INFO
---------------
1102 03-MAR-08 11.44.02.827232 AM -07:00 TRY2 SUCCEEDED 0