RE: Jobs Question
Date: Fri, 04 Apr 2014 20:15:16 +0000
Message-id: <3653B77DCF6DDA4ABAD1E9416F1876D73FE82EB2_at_ex03mail02.ad.rit.edu>
I was able to get the job removed. It was left over from an application upgrade, so it doesn't need to be migrated.
Thank you to everyone, your answers were extremely helpful!
Scott Canaan '88 (srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>)
(585) 475-7886 - work (585) 339-8659 - cell"Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer
From: Maaz Anjum [mailto:maazanjum_at_gmail.com]
Sent: Friday, April 04, 2014 4:14 PM
To: jure.bratina_at_gmail.com
Cc: Mark Bobak; Scott Canaan; oracle-l_at_freelists.org
Subject: Re: Jobs Question
Would you consider migrating to DBMS_SCHEDULER from DBMS_JOBS?
Tim Hall, wrote about it (the 10g version) a few years ago but it is still relevant. http://www.oracle-base.com/articles/10g/scheduler-10g.php
Cheers,
Maaz
On Fri, Apr 4, 2014 at 3:51 PM, Jure Bratina <jure.bratina_at_gmail.com<mailto:jure.bratina_at_gmail.com>> wrote:
Or you can use the DBMS_IJOB.REMOVE procedure as described here: http://oradbatips.blogspot.com/2010/05/tip-87-createremove-jobs-for-other.html
Regards,
Jure
On Fri, Apr 4, 2014 at 8:29 PM, Mark Bobak <Mark.Bobak_at_proquest.com<mailto:Mark.Bobak_at_proquest.com>> wrote:
I believe you need to be connected as the user who created the job.
-Mark
--
A life yet to be lived...
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 04 2014 - 22:15:16 CEST