Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Need help with DBMS_JOB

Re: Need help with DBMS_JOB

From: Igor Laletin <ivl_at_ftc.ru>
Date: 1997/06/24
Message-ID: <5oo4n3$rn9$1@gts.nsk.su>#1/1

 Frank Tropschuh wrote in article <33AE3B92.8C6020CF_at_ubs.ch>...
>I cannot submit a new job -- any suggestions?

[skipped]

>SQL> VARIABLE ANALYZE_ID NUMBER;
>SQL> EXECUTE DBMS_JOB.submit(:ANALYZE_ID, 'PG_JOBS.ANALYZE(0)', SYSDATE,
>'SYSDATE + 1');
dbms_job.submit inserts "what" parameter into following pl/sql block:

DECLARE
job BINARY_INTEGER := :job;
 next_date DATE := :mydate;
  broken BOOLEAN := FALSE;
 BEGIN
<"what" parameter>
 :mydate := next_date;
 IF broken THEN :b := 1; ELSE :b := 0; END IF;  END; So you should add a semicolon at the end of your "what" parameter. And don't forget to commit after submit.

Igor Laletin
Financial Technologies Center, Novosibirsk, Russia Received on Tue Jun 24 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US