2012年2月16日

Oracle Kill 正在运行的 Job

摘要: 转自:http://levicorp.com/2009/05/22/how-to-kill-the-running-job/1. Check the running Job (From here you will get the SID thatrunning the Job)SQL> SELECT * FROM DBA_JOBS_RUNNING;2. Make Job become Broken/offlineBEGIN SYS.DBMS_IJOB.BROKEN(job#,TRUE); END;SQL> BEGIN SYS.DBMS_IJOB.BROKEN('136451 阅读全文

posted @ 2012-02-16 19:55 spring3mvc学习笔记 阅读(254) 评论(0) 推荐(0) 编辑

导航