Re: Jobs Question

On Friday, April 4, 2014, Iggy Fernandez <iggy_fernandez_at_hotmail.com> wrote:

> 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_at_gmail.com<javascript:_e(%7B%7D,'cvml','maazanjum_at_gmail.com');>
> To: jure.bratina_at_gmail.com<javascript:_e(%7B%7D,'cvml','jure.bratina_at_gmail.com');>
> CC: Mark.Bobak_at_proquest.com<javascript:_e(%7B%7D,'cvml','Mark.Bobak_at_proquest.com');>;
> srcdco_at_rit.edu <javascript:_e(%7B%7D,'cvml','srcdco_at_rit.edu');>;
> oracle-l_at_freelists.org<javascript:_e(%7B%7D,'cvml','oracle-l_at_freelists.org');>
>
> 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<javascript:_e(%7B%7D,'cvml','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<javascript:_e(%7B%7D,'cvml','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...
>

-- 
A life yet to be lived...

--
http://www.freelists.org/webpage/oracle-l