Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: External Table vs Sql Loader
On Feb 11, 7:33 pm, HansF <Fuzzy.Greybe..._at_gmail.com> wrote:
> On Sun, 11 Feb 2007 14:32:40 -0800, Mark D Powell wrote:
> > On Feb 10, 11:13 pm, HansF <Fuzzy.Greybe..._at_gmail.com> wrote:
> >> On Sat, 10 Feb 2007 17:00:31 -0800, Mark D Powell wrote:
> >> > On Feb 9, 9:11 pm, "Anurag Varma" <avora..._at_gmail.com> wrote:
>
> >> > The Oracle scheduler, dbms_scheduler, does not provide the standard
> >> > job dependency capabilities of true job management systems. These
> >> > systems offer file dependencies, job depenencies, allow creation of
>
> >> Have you seen the 10g R2 'events schedule' and 'job chain' enhancements?
>
> > Possibility not. I will have to look again since the term job chain
> > does not ring any bells and my doco at home is labeled 10.1. I will
> > check my 10.2 doc at work.
>
> You may be pleasantly surprised - at least some of the advanced
> functionality you deem to be part of 'true job management systems' is now
> part of the job scheduler.
>
> That said, the syntax and UI are typical 'Oracle'. <g>
>
> --
> Hans Forbrich (mailto: Fuzzy.GreyBeard_at_gmail.com)
> *** Feel free to correct me when I'm wrong!
> *** Top posting [replies] guarantees I won't respond.- Hide quoted text -
>
> - Show quoted text -
A chain looks to be much like a traditional job and the ability to execute each step based on the prior step working successfully is good, but the feature is still limited. I would say that dbms_scheduler is now probably good enough for some smaller shops that have simple requirements and do not want to spend $$ on a scheduler product to get away without buying one or the alternate of having to script all the dependencies manually.
Thanks for pointing this new mid-release feature enhancement out.
![]() |
![]() |