Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Errors running scheduled job
Paul BJ wrote:
> Oracle 9i on Unix (HP-UX I think).
>
> I have just written a job to run each day at 23:55.
>
>
> If I execute the code in the SP on its own it executes OK and produces the
> desired result.
>
> If I Right click on the job and select execute, it executes OK and produces
> the desired result.
>
> But when the job runs at 23:55 (or indeed at any other time ; we have tried
> lots of different times) it always fails.
>
> The code for the job is:
> begin
>
> sys.dbms_job.change(job => :job, what => :what, next_date => :next_date,
> interval => :interval); end;
>
> :JOB=763
>
> :WHAT=LUXPROJECT.SP_RESET_EXEC_TIME;
>
> :NEXT_DATE=04/18/2005 6:18:08 PM
>
> :INTERVAL=SYSDATE+30/1440
>
> (the interval has testing params in it but the result is the same if we use
> the real params; run once per day at 23:55)
>
>
>
> The SP contains:
>
> Update ad_parameters
>
> Set Loading_start_time = '00:01';
>
> commit;
>
> Anyone know what the problem might be?
>
> TIA
>
> Paul BJ
With what error message?
With what written to the alert log?
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Mon Apr 18 2005 - 12:27:01 CDT