关于pl/sql中的jobs的用法

Question

像大家请教一下pl/sql中的jobs的用法？？？
jobs是做什么用的？

Answer 1

定时执行某些任务的.可以参照dbms_job包.

Answer 2

job 是用来定时运行程序的
如果不会用可能用PL/SQL DEVELOPER设定就行了，

Answer 3

就像是mssql 里面的作业   定时运行某个sql脚本

Answer 4

嗯，谢谢大家了，我在到网上找找job具体怎么用······

Answer 5

这两个都是高手啊，我刚让人家帮忙解决了关于job的停止与删除问题

Answer 6

参考下面的.
1.dbms_job.submit 创建job
SQL> create or replace procedure resch as
  2  begin
  3  delete from emp where empno = 2;
  4  COMMIT;
  5  delete from emp where empno = 3;
  6  COMMIT;
  7  delete from emp where empno = 4;
  8  COMMIT;
  9  end;
 10  /
 
Procedure created
 
SQL> set serveroutput on
SQL> 
SQL> DECLARE
  2  v_job NUMBER(20);
  3  BEGIN
  4  dbms_job.submit(v_job,'begin resch; end;',SYSDATE,'SYSDATE+1/24/60');
  5  dbms_output.put_line(v_job);
  6  END;
  7  /
 
70
 
PL/SQL procedure successfully completed
 
SQL> select * from dba_jobs t where t.JOB=70;
 
       JOB LOG_USER                       PRIV_USER                      SCHEMA_USER                    LAST_DATE   LAST_SEC         THIS_DATE   THIS_SEC         NEXT_DATE   NEXT_SEC         TOTAL_TIME BROKEN INTERVAL                                                                           FAILURES WHAT                                                                             NLS_ENV                                                                          MISC_ENV                                                           INSTANCE
---------- ------------------------------ ------------------------------ ------------------------------ ----------- ---------------- ----------- ---------------- ----------- ---------------- ---------- ------ -------------------------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------------------------------------------------------------- ----------
        87 SCOTT                          SCOTT                          SCOTT                                                                                    2010-8-25 1 17:09:25                  0 N      SYSDATE+1/24/60                                                                             begin resch; end;                                                                NLS_LANGUAGE='SIMPLIFIED CHINESE' NLS_TERRITORY='CHINA' NLS_CURRENCY='￥' NLS_ISO 0102000200000000                                                          0
 
SQL>
2.dbms_job.broken 停止job或唤醒jobSQL> exec dbms_job.broken(job => 87,broken => true,next_date => sysdate);--停止job
 
PL/SQL procedure successfully completed
 
SQL> commit;
 
Commit complete
 
SQL> exec dbms_job.broken(job => 87,broken => false,next_date => sysdate);--唤醒job
 
PL/SQL procedure successfully completed
 
SQL> commit
  2  ;
 
Commit complete
 
SQL>  
3.dbms_job.remove 删除job
SQL> exec dbms_job.remove(job => 87);--删除job
 
PL/SQL procedure successfully completed
 
SQL> commit;
 
Commit complete
 
SQL> select * from dba_jobs t where t.JOB=87;--已无数据
 
       JOB LOG_USER                       PRIV_USER                      SCHEMA_USER                    LAST_DATE   LAST_SEC         THIS_DATE   THIS_SEC         NEXT_DATE   NEXT_SEC         TOTAL_TIME BROKEN INTERVAL                                                                           FAILURES WHAT                                                                             NLS_ENV                                                                          MISC_ENV                                                           INSTANCE
---------- ------------------------------ ------------------------------ ------------------------------ ----------- ---------------- ----------- ---------------- ----------- ---------------- ---------- ------ -------------------------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------------------------------------------------------------- ----------
 
SQL>