Re: Does Oracle Job cost a lot of System resource?

Oxnard 写道：

> "Dick" <tingjun.li_at_gmail.com> wrote in message
> news:1151593943.173850.207730_at_p79g2000cwp.googlegroups.com...
> > Does Oracle Job cost a lot of System resources?
> >
> > variable myjob number;
> > /
> > begin
> > dbms_job.submit(:myjob,'pMovesheetTohistory(2,
> > 2);',trunc(sysdate)+36/24,'trunc(sysdate)+36/24');
> > end;
> > /
> > begin
> > dbms_job.run(:myjob);
> > end;
> > /
> >
> > Or should I write a program to call my procedure daily, - our system is
> > prepared to run for a very long time (maybe more than one year..)
> >
> > Any links or clues are appreciated.
> >
>
> no

What about running 80 jobs (or more)? Is there maximum number? Received on Thu Jun 29 2006 - 20:22:46 CDT