\n\t–\u83b7\u53d6\u65f6\u95f4\u548c\u5e8f\u5217
\n\tcreate sequence numbincrease_s;
\n\tcreate table machineTime(seq number,mtime date);\n<\/p>\n
\n\t–\u5b58\u50a8\u8fc7\u7a0b
\n\tcreate or replace procedure getMachineTime as
\n\tbegin
\n\t insert into machineTime values (numbincrease_s.nextval,sysdate);
\n\t commit;
\n\tend;\n<\/p>\n
\n\t–\u5b9a\u4e49jobs\u8c03\u7528\u4e0a\u8ff0\u5b58\u50a8\u8fc7\u7a0b,\u4e3a\u4e86\u770b\u51fa\u6548\u679c\u4e00\u5206\u949f\u6267\u884c\u4e00\u6b21
\n\tdeclare
\n\t jobs number;
\n\tbegin
\n\t sys.dbms_job.submit(jobs, 'getMachineTime;', sysdate, 'sysdate+1\/1440');
\n\t commit;
\n\tend;\n<\/p>\n
\n\t–\u5220\u9664Job
\n\t\/*begin
\n\t –select job from user_jobs;
\n\t sys.dbms_job.remove(108); –job_id
\n\t commit;
\n\tend;*\/\n<\/p>\n
\n\t–select * from dba_jobs;
\n\t–select * from all_jobs;
\n\t–select * from user_jobs;\n<\/p>\n
\n\t–\u4e0b\u9762\u662f\u5e26\u53c2\u6570\u7684\u5b58\u50a8\u8fc7\u7a0b\u7684\u8c03\u7528
\n\t\/*begin
\n\t sys.dbms_job.submit(job => :job,
\n\t what => 'declare s1 varchar2(200); s2 varchar2(200); begin xxx.xxxxxx(s1,s2); end;',
\n\t next_date => sysdate,
\n\t interval => 'sysdate+1\/1440');
\n\t commit;
\n\tend;*\/
\n\t–\u8c03\u7528\u7cfb\u7edf\u5b9a\u4e49\u7684\u5b58\u50a8\u8fc7\u7a0b\u7c7b\u4f3c\u4e0a\u8ff0\u65b9\u5f0f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
–\u83b7\u53d6\u65f6\u95f4\u548c\u5e8f\u5217 create sequence numbincrease_s; create t … \u7ee7\u7eed\u9605\u8bfbOracle\u521b\u5efaJob\u547d\u4ee4<\/span>