variable job1 varchar2:='smsjob';
BEGIN
SYS.DBMS_JOB.SUBMIT
(
job => :job1,
what => 'declare v_temp integer;begin v_temp := SMSalerts();end;',
next_date => trunc(sysdate+1)+9/24,
interval => 'trunc(sysdate+1)+9/24',
no_parse => FALSE
);
commit;
END;创建好的JOB叫41,再创建叫42,我想指定job的名字 该怎么写
BEGIN
SYS.DBMS_JOB.SUBMIT
(
job => :job1,
what => 'declare v_temp integer;begin v_temp := SMSalerts();end;',
next_date => trunc(sysdate+1)+9/24,
interval => 'trunc(sysdate+1)+9/24',
no_parse => FALSE
);
commit;
END;创建好的JOB叫41,再创建叫42,我想指定job的名字 该怎么写
DBMS_JOB.SUBMIT(
JOB OUT BINARY_INTEGER,
WHAT IN VARCHAR2, NEXT_DATE IN DATE DEFAULTSYSDATE,
INTERVAL IN VARCHAR2 DEFAULT 'NULL',
NO_PARSE IN BOOLEAN DEFAULT FALSE,
INSTANCE IN BINARY_INTEGER DEFAULT ANY_INSTANCE,
FORCE IN BOOLEAN DEFAULT FALSE);这个job是out,不是用来输入的,可见这个jobid是由系统自动生成的,而不能人工输入。