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

From: Oxnard <oxnardNO_SPAM_at_comcast.net>
Date: Thu, 29 Jun 2006 10:31:16 -0500
Message-ID: <Z6qdnXDbYI3Tbz7ZnZ2dnUVZ_umdnZ2d@comcast.com>

"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 Received on Thu Jun 29 2006 - 10:31:16 CDT