Question

Oracle数据库在PL/SQL Developer下创建作业job出错

Answer 1

PL/SQL Developer下可以创建：
但你没有定义变量job，另外what内容需要以分号结尾。

SQL> variable job number;
SQL> begin
2 sys.dbms_job.submit(job=>:job,
3 what=>'clientwaring;',
4 next_date=>to_date('31-07-2010 10:09:36','dd-mm-yyyy hh24:mi:ss'),
5 interval=>'sysdate+1/1440');
6 commit;
7 end;
8 /

PL/SQL procedure successfully completed
job
---------
42

Answer 2

job最好用sql plus创建，打开sql plus一行一行的执行。因为创建job要使用变量，pl/sql developer不支持变量。

Answer 3

DECLARE
nowtime VARCHAR2(100);
test_job NUMBER;
BEGIN
sys.dbms_job.submit(job => test_job, what => 'select sysdate into nowTime from dual;', next_date => SYSDATE, INTERVAL => 'sysdate+1/1440', no_parse => TRUE);
COMMIT;
END;
/

Answer 4

你把commit那一句去掉试试。

Answer 5

请参考：
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'PRC_KPI_FLTKPIMONITOR;'
,next_date => to_date('24-06-2009 12:00:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'TRUNC(sysdate,''mi'') + 1/48'
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END;
/