我想在Oracle Database 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:
1 回答
https://docs.oracle.com/database/121/ARPLS/d_sched.htm#ARPLS72302