Re: Oracle job restarts everytime it is broken and unbroken
Date: Mon, 4 Feb 2008 08:39:01 -0800 (PST)
On Feb 2, 3:21 pm, Massa Batheli <mng..._at_gmail.com> wrote:
> The propose of the job is to run only on Fridays at 9 .
> All jobs have to be broken at one time or the other for routine
> maintainance .
> Surprisingly once the jobs are re enabled job 777 which brings
> the system to its knees kicks off .Your help will be greatly
> appreciated in this
> -- JOB7777 (Job)
> X NUMBER;
> ( job => X
> ,what => 'PurchaseAPI.TruckAvailability;'
> ,next_date => to_date('01/01/4000 00:00:00','dd/mm/yyyy
> ,interval => 'trunc(next_day(sysdate, ''FRI'')) + 21/24'
> ,no_parse => FALSE
> SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
> (job => X,
> broken => TRUE);
If 10G and above .. use job scheduler.
You can write the logic on when the underlying procedure is to be run in a wrapper.
That wrapper procedure can have the code where it will only run during spcified
time / date interval. The dbms_job can then call that wrapper.
Anurag Received on Mon Feb 04 2008 - 10:39:01 CST