Re: Jobs Question
- From: Maaz Anjum <maazanjum@xxxxxxxxx>
- To: Iggy Fernandez <iggy_fernandez@xxxxxxxxxxx>
- Date: Fri, 4 Apr 2014 17:09:59 -0400
Good and valid point.
On Friday, April 4, 2014, Iggy Fernandez <iggy_fernandez@xxxxxxxxxxx> 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@xxxxxxxxx<javascript:_e(%7B%7D,'cvml','maazanjum@xxxxxxxxx');>
> To:
> jure.bratina@xxxxxxxxx<javascript:_e(%7B%7D,'cvml','jure.bratina@xxxxxxxxx');>
> CC:
> Mark.Bobak@xxxxxxxxxxxx<javascript:_e(%7B%7D,'cvml','Mark.Bobak@xxxxxxxxxxxx');>;
> srcdco@xxxxxxx <javascript:_e(%7B%7D,'cvml','srcdco@xxxxxxx');>;
> oracle-l@xxxxxxxxxxxxx<javascript:_e(%7B%7D,'cvml','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<javascript:_e(%7B%7D,'cvml','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<javascript:_e(%7B%7D,'cvml','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...
>
--
A life yet to be lived...
Other related posts:
