Re: Job submission: interval error

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

Sorry about the typos - I meant

DECLARE
  JobNumber NUMBER;
BEGIN
  DBMS_JOB.SUBMIT(:JobNumber,
    'TX.GenerateWeeklyData;',
    SysDate,
    'NEXT_DAY(TRUNC(SysDate),'SUNDAY')+0.5'); END; "Lee Staples" <lee_at_cybicom.co.za> wrote in message news:994406616.785184_at_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:42:44 CDT