蜡笔君的博客

原创 ORACLE JOB常用操作

//查询job信息 select * from user_jobs; //查询job是否正在执行 select * from dba_jobs_running where job='job号'; //想要杀job select b.sid,b.serial# from dba_jobs_running a, v$session b where a.sid=b.sid and a.job='job号'; alter system kill session '会话编号sid,会话序列号serial#';