Job submission: interval error

From: Lee Staples <lee_at_cybicom.co.za>
Date: Fri, 6 Jul 2001 10:01:56 +0200
Message-ID: <994406616.785184@proxy.storm.co.za>

Oracle 8.0.4

I am attempting to submit a job using the following:

DECLARE
  JobNumber NUMBER;
BEGIN
  DBMS_JOB.SUBMIT(:JobNumber,
'TX.GenerateWeeklyData;',

    SysDate,
'NEXT_DAY(TRUNC(SysDate,'SUNDAY')+0.5';
END; as I want the job to run every Sunday at noon. But I keep getting a PL/SQL compiler error complaining about 'SUNDAY'. This happens regardless of the day I use. I can't get it to accept the NEXT_DAY function at all for the interval.

Any ideas?

Thanks,
Lee. Received on Fri Jul 06 2001 - 03:01:56 CDT