oracle job 杂

当前用户下查询作业：
select priv_user,job,what from user_jobs;

删除当前用户下作业：

dbms_job.remove(:job_num);
commit;

 

===================================================================================================
管理员权限：
--查看所有job;
select * from dba_jobs;
--查看正在运行的job;
select * from dba_jobs_running;
--根据sid查出对应的session;
select SID,SERIAL# from V$Session where SID='&SID';
--kill对应的session;
alter system kill session '&SID,&SERIAL';
--将job置为broken;
exec dbms_job.broken('&JOB',true);
--sysdba用户权限删除job;
delete from dba_jobs where JOB='&JOB';
====================================================================================================
  procedure deletejob is
    ---删除存jjob oracle10g专用 by yanleigis email:[e-mail]
    cursor c1 is  select b.JOB from user_jobs b;
   begin
    for rr in c1 LOOP
      begin
        dbms_job.remove(rr.job);
         exception
           when others then
            dbms_output.put_line(sqlcode || ':' || sqlerrm);
       end;
     end loop;
  end;

select 'drop view ' || view_name||';'||chr(13)||chr(10) from user_views;

select 'dbms_job.remove(rr.job)' ||job||';'||chr(13)||chr(10) from user_jobs