Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as focususer
SQL>
SQL> --JOB 需要在命令行执行；
SQL> --抽数job
SQL> CREATE OR REPLACE PROCEDURE RPT
2 --业务
3 AS
4 v_time VARCHAR2(20); /*运行当天*/
5 v_timeold VARCHAR2(20); /*运行前一天*/
6
7 BEGIN
8 --查询系统时间
9 select to_char(sysdate, 'yyyy-mm-dd'), to_char(sysdate - 1, 'yyyy-mm-dd')
10 into v_time, v_timeold
11 from dual;
47 commit;
48 --异常情况处理
49
50 EXCEPTION
51 WHEN OTHERS THEN
52 ROLLBACK;
53 END RPT;
54 /
Procedure created
SQL> --新建JOB
SQL> --SM_MANUAL_SM_LIST的job
SQL> variable job2 number;
SQL> begin
2 sys.dbms_job.submit(:job2,
3 'RPT;',
4 to_date('22-03-2016 06:00:00',
5 'dd-mm-yyyy hh24:mi:ss'),
6 'TRUNC(SYSDATE+1,''DD'')+360/1440');
7 commit;
8 end;
9 /
PL/SQL procedure successfully completed
job2
---------
69
SQL> commit;
Commit complete
SQL> --启动JOB
SQL> begin
2 sys.dbms_job.run(:job2);
3 end;
4 /
PL/SQL procedure successfully completed
job2
---------
69
SQL> --移除JOB
SQL> begin
2 sys.dbms_job.remove(:job2);
3 end;
4 /
PL/SQL procedure successfully completed
job2
---------
69
