tag:blogger.com,1999:blog-697307722356110163.post3233541515265325190..comments2023-10-19T08:14:15.629-04:00Comments on Halimdba: How to stop a running job of DBMS_JOB ?halimdbahttp://www.blogger.com/profile/06064045814557676169noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-697307722356110163.post-57899568734537525632017-11-02T07:17:13.119-04:002017-11-02T07:17:13.119-04:00You have to connect to the database as the owner o...You have to connect to the database as the owner of the job. If you don't, you can't mark the job as broken, not even when you are logged in as SYS:<br /><br />ORA-23421: job number 66694 is not a job in the job queueKeeshttps://www.blogger.com/profile/18274859843304056167noreply@blogger.comtag:blogger.com,1999:blog-697307722356110163.post-64370875628735509992016-02-19T02:23:36.166-05:002016-02-19T02:23:36.166-05:00+1 for a great post. Can I add that if the job is...+1 for a great post. Can I add that if the job is owned by SYS, it looks like you have to use DBMS_IJOB? I was logged in as SYS and couldn't mark my AQ jobs as broken without it.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-697307722356110163.post-91992937599817199932014-07-12T02:45:17.065-04:002014-07-12T02:45:17.065-04:00Very good post. Helped me to save my timeVery good post. Helped me to save my timeRajhttps://www.blogger.com/profile/17149396398806095795noreply@blogger.comtag:blogger.com,1999:blog-697307722356110163.post-36623162364486185422014-06-06T17:09:37.704-04:002014-06-06T17:09:37.704-04:00This was excellent and well estructured. Just one ...This was excellent and well estructured. Just one correction for the linux command. In mine it worked with -9 spid instead of the '9 spid<br /><br />Regards,<br /><br />EricAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-697307722356110163.post-76016377532743818782013-12-02T05:48:59.450-05:002013-12-02T05:48:59.450-05:00Excellent .. too good post. I was having issue, jo...Excellent .. too good post. I was having issue, job was reappearing even after killing job from oracle and os pid also. <br /><br />Thanks a lot..<br /><br />-Siva<br />Anonymousnoreply@blogger.com