Re: Need help with DBMS_JOB

 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