RE: Jobs Question

  • From: Iggy Fernandez <iggy_fernandez@xxxxxxxxxxx>
  • To: "maazanjum@xxxxxxxxx" <maazanjum@xxxxxxxxx>, "jure.bratina@xxxxxxxxx" <jure.bratina@xxxxxxxxx>
  • Date: Fri, 4 Apr 2014 14:01:42 -0700

Apparently Oracle itself has not heard the message (about DBMS_SCHEDULER) 
because DBMS_JOBS is still used for refreshes of materialized views.
Iggy


Date: Fri, 4 Apr 2014 16:13:54 -0400
Subject: Re: Jobs Question
From: maazanjum@xxxxxxxxx
To: jure.bratina@xxxxxxxxx
CC: Mark.Bobak@xxxxxxxxxxxx; srcdco@xxxxxxx; oracle-l@xxxxxxxxxxxxx

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@xxxxxxxxx> 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@xxxxxxxxxxxx> wrote:








I believe you need to be connected as the user who created the job.



-Mark



-- 
A life yet to be lived...
                                          

Other related posts: