oracle使用job包,Oracle JOB 使用方法

SVRMGR> select * from dba_jobs;

初始化相关参数job_queue_processes

alter system set job_queue_processes=39 scope=spfile;//最大值不能超过1000 ;job_queue_interval = 10 //调度作业刷新频率秒为单位

DBA_JOBS describes all jobs in the database.

USER_JOBS describes all jobs owned by the current user

1 select job,what,to_char(last_date,'yyyy-mm-dd HH24:mi:ss'),to_char(next_date,'yyyy-mm-dd HH24:m),interval from dba_jobs where job in (325,295)

2 select job,what,last_date,next_date,interval from dba_jobs where job in (1,3);

查询job的情况。

show paramter background_dump_dest.

看alter.log 和trace

SVRMGR> select * from dba_jobs;

初始化相关参数job_queue_processes

alter system set job_queue_processes=39 scope=spfile;//最大值不能超过1000

job_queue_interval = 10 //调度作业刷新频率秒为单位

DBA_JOBS describes all jobs in the database.

USER_JOBS describes all jobs owned by the current user

1 select job,what,to_char(last_date,'yyyy-mm-dd HH24:mi:ss'),to_char(next_date,'yyyy-mm-dd HH24:m),interval from dba_jobs where job in (325,295)

2 select job,what,last_date,next_date,interval from dba_jobs where job in (1,3);

查询job的情况。

show paramter background_dump_dest.

看alter.log 和trace

请问我如何停止一个JOB

SQL> exec dbms_job.broken(1,true)

PL/SQL 过程已成功完成。

SQL>commit //必须提交否则无效

启动作业

SQL> exec dbms_job.broken(1,false)

PL/SQL 过程已成功完成。

停其他用户的job

SQL>exec sys.dbms_ijob.broken(98,true);

SQL>commit;

============================

exec dbms_job.broken(:job) 停止

exec dbms_job.broken(186,true) //标记位broken

exec dbms_job.broken(186,false)//标记为非broken

exec dbms_job.broken(186,false,next_day(sysdate,'monday')) //标记为非broken,指定执行时间

exec dbms_job.remove(:job)；删除

exec dbms_job.remove(186);

commit；

把一个broken job重新运行

三、查看相关job信息

1、相关视图

dba_jobs

all_jobs

user_jobs

dba_jobs_running 包含正在运行job相关信息

创建JOB

variable jobno number;

begin

dbms_job.submit(:jobno, 'st