不带参数:
首先有一个shell脚本:
[oracle@linux shell]$ cat mk.sh
#!/bin/bash
mkdir -p /u01/app/oracle/shell/t1
[oracle@linux shell]$ ll
总计 8
-rwxr-xr-x 1 oracle oinstall 25 11-13 07:01 mkdir.sh
-rwxr-xr-x 1 oracle oinstall 46 11-13 07:08 mk.sh
注意:这里必须使用sys用户。不然可能会遇到权限问题!(conn /as sysdba)
SQL> show user
USER 为 "SYS"
SQL> exec dbms_scheduler.create_job(job_name=>'j_test',job_type=>'executable',job_action=>'/u01/app/oracle/shell/mk.sh');
PL/SQL 过程已成功完成。
SQL> exec dbms_scheduler.enable('j_test');
PL/SQL 过程已成功完成。
可以看见t1目录已经创建出来拉!
[oracle@linux shell]$ ll
总计 12
-rwxr-xr-x 1 oracle oinstall 25 11-13 07:01 mkdir.sh
-rwxr-xr-x 1 oracle oinstall 46 11-13 07:08 mk.sh
drwxr-xr-x 2 oracle oinstall 4096 11-13 07:23 t1
其实能调用到不到参数的shell脚本就基本够用了。通常情况都是一些备份脚本!!!
带参数的:
shell脚本:
[oracle@linux shell]$ pwd
/u01/app/oracle/shell
[oracle@linux shell]$ cat mkdir.sh
#!/bin/bash
mkdir /u01/app/oracle/shell/${1}
注意:手动执行jobs是不增加RUN_COUNT的。
SQL> show user
USER 为 "SYS"
SQL> exec dbms_scheduler.create_job(job_name=>'j_test',job_type=>'executable',job_action=>'/u01/app/oracle/shell/mkdir.sh',start_date=>sysdate,repeat_interval=>'freq=daily;interval=1',number_of_arguments=>1);
PL/SQL 过程已成功完成。
SQL> select job_name,job_type,job_action,start_date,repeat_interval,end_date,enabled,auto_drop,state,run_count,max_runs from user_scheduler_jobs where job_name = 'J_TEST';
JOB_NAME JOB_TYPE JOB_ACTION START_DATE REPEAT_INT END_DATE ENABL AUTO_ STATE RUN_COUNT MAX_RUNS
------------------------------ ---------------- ---------- --------------- ---------- ---------- ----- ----- --------------- ---------- ----------
J_TEST EXECUTABLE /u01/app/o 13-11月-11 07.3 freq=daily FALSE TRUE DISABLED 0
racle/shel 1.39.000000 上 ;interval=
l/mkdir.sh 午 +08:00 1
SQL> exec dbms_scheduler.set_job_argument_value('j_test',1,'test');
PL/SQL 过程已成功完成。
SQL> select * from user_scheduler_job_args where job_name = 'J_TEST';
JOB_NAME ARGUMENT_N ARGUMENT_POSITION ARGUMENT_T VALUE ANYDATA_VA OUT_A
------------------------------ ---------- ----------------- ---------- ---------- ---------- -----
J_TEST ########## UNDEFINED test ANYDATA()
SQL> exec dbms_scheduler.enable('j_test');
PL/SQL 过程已成功完成。
SQL> select job_name,job_type,job_action,start_date,repeat_interval,end_date,enabled,auto_drop,state,run_count,max_runs from user_scheduler_jobs where job_name = 'J_TEST';
JOB_NAME JOB_TYPE JOB_ACTION START_DATE REPEAT_INT END_DATE ENABL AUTO_ STATE RUN_COUNT MAX_RUNS
------------------------------ ---------------- ---------- --------------- ---------- ---------- ----- ----- --------------- ---------- ----------
J_TEST EXECUTABLE /u01/app/o 13-11月-11 07.3 freq=daily TRUE TRUE SCHEDULED 0
racle/shel 1.39.000000 上 ;interval=
l/mkdir.sh 午 +08:00 1
SQL> exec dbms_scheduler.run_job('j_test');
PL/SQL 过程已成功完成。
SQL> select job_name,job_type,job_action,start_date,repeat_interval,end_date,enabled,auto_drop,state,run_count,max_runs from user_scheduler_jobs where job_name = 'J_TEST';
JOB_NAME JOB_TYPE JOB_ACTION START_DATE REPEAT_INT END_DATE ENABL AUTO_ STATE RUN_COUNT MAX_RUNS
------------------------------ ---------------- ---------- --------------- ---------- ---------- ----- ----- --------------- ---------- ----------
J_TEST EXECUTABLE /u01/app/o 13-11月-11 07.3 freq=daily TRUE TRUE SCHEDULED 0
racle/shel 1.39.000000 上 ;interval=
l/mkdir.sh 午 +08:00 1
可以看见test目录已经创建:
[oracle@linux shell]$ ll
总计 12
-rwxr-xr-x 1 oracle oinstall 45 11-13 07:27 mkdir.sh
-rwxr-xr-x 1 oracle oinstall 46 11-13 07:08 mk.sh
drwxr-xr-x 2 oracle oinstall 4096 11-13 07:37 test