Oracle:在作业dbms_scheduler中定义dbms_scheduler

Question

我想在Oracle数据库11g速成版11.2.0.2.0 -64位产品中创建一个优先级最高的作业

BEGIN
  DBMS_SCHEDULER.CREATE_JOB (
   job_name         =>  'parseMsg',
   job_type         =>  'PLSQL_BLOCK',
   job_action       =>  'begin S_IN_TDK.parseMsg; end;',
   repeat_interval  =>  'FREQ=SECONDLY;INTERVAL=1',
   enabled          =>  true,
   job_priority     =>  1,
   comments         => 'Job that polls device n2 every 1 seconds');
END;

但我发现了一个错误：

Informe de error -
ORA-06550: line 2, column 3:
PLS-00306: wrong number or types of arguments in call to 'CREATE_JOB'
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
06550. 00000 -  "line %s, column %s:\n%s"
*Cause:    Usually a PL/SQL compilation error.
*Action:

Answer 1

sched.htm#ARPLS72302

并非所有可能的作业属性都可以用CREATE_JOB设置。一些必须在创建作业后设置。例如，作业参数必须与SET_JOB_ARGUMENT_VALUE过程或SET_JOB_ANYDATA_VALUE过程一起设置。其他作业属性(如job_priority和max_runs )是用SET_ATTRIBUTE过程设置的。