当前用户下查询作业:
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:landgis@126.com
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