17,081
社区成员
发帖
与我相关
我的任务
分享
declare
job number;
begin
sys.dbms_job.submit(job => job,
what => 'ctmc_updateprice_proc;',
next_date => to_date('2008-12-1 00:00:00',
'yyyy-mm-dd hh24:mi:ss'),
interval => 'trunc(add_months(sysdate,1) ,''mm'')');
commit;
end;
/
begin
sys.dbms_job.submit(job => :job,
what => 'ctmc_updateprice_proc;',
next_date => to_date('2008-12-1 00:00:00',
'yyyy-mm-dd hh24:mi:ss'),
interval => 'trunc(add_months(sysdate,1) ,' mm ')');
commit;
end;
/
VARIABLE JOBNO NUMBER;
begin
sys.dbms_job.submit(:JOBNO,
'insert into table_name(zs) -- 你的表名字段.
select count(*) from contract
where contractdate >= add_months(trunc(sysdate,''mm''),-1) ;commit;',
sysdate,
'add_months(trunc(sysdate,''mm''),1)');
commit;
end;
/
VARIABLE JOBNO NUMBER;
begin
sys.dbms_job.submit(:JOBNO,
'insert ino table_name(zs)
select count(*) from contract
where contractdate >= add_months(trunc(sysdate,''mm''),-1) ;',
sysdate,
'add_months(trunc(sysdate,''mm''),1)');
commit;
end;
/
BEGIN
SYS.DBMS_JOB.REMOVE(181);
COMMIT;
END;
/
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'CHINA.SP_MAKE_AB071
(''SYSTEM'' /* VARCHAR2 */ );'
,next_date => to_date('01/12/2008 02:00:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'TRUNC(LAST_DAY(SYSDATE)) + 1+1/12'
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END;
/