2012年2月16日
摘要: 转自: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 springside例子 阅读(467) 评论(0) 推荐(0) 编辑