用DBMS_JOB包来实现
一个每天0:00执行的例子,在SQLPLUS中敲入如下几行:
job out binary_integer
dbms_job.submit(job=>:jobno,
what=>'do_sth();',
next_date=>trunc(sysdate+1),
interval=>'trunc(sysdate+1)'
);
/
一个每天0:00执行的例子,在SQLPLUS中敲入如下几行:
job out binary_integer
dbms_job.submit(job=>:jobno,
what=>'do_sth();',
next_date=>trunc(sysdate+1),
interval=>'trunc(sysdate+1)'
);
/
variable jobno number
dbms_job.submit(job=>:jobno,
what=>'do_sth();',
next_date=>trunc(sysdate+1),
interval=>'trunc(sysdate+1)'
);
/