| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Does Oracle Job cost a lot of System resource?
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. Received on Thu Jun 29 2006 - 10:12:23 CDT
 |
 |