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


Oxnard 写道：

"***" <tingjun.li@xxxxxxxxx> wrote in message
news:1151593943.173850.207730@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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?

.

Quantcast