Errors running scheduled job

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 Received on Mon Apr 18 2005 - 12:07:53 CDT