dbms_job

Giganews Newsgroups
Subject: dbms_job
Posted by:  rjgst3 (rjgs…@rmu.edu)
Date: 28 Aug 2006

I'm fairly new as creating dbms_job but I feel that what I'm trying to
do is fairly simple.  Heres what I have:

VARIABLE b_job number

BEGIN
DBMS_JOB.SUBMIT(JOB => :b_job,
WHAT => 'insert into tbl select * from test_data;',
NEXT_DATE => sysdate,
INTERVAL => 'sysdate+1');
COMMIT;
End

This will not commit, and I get an 'Invalid Sql'.  Granted, the sql in
the example is genric, I confirmed 3 times that the insert sql
statement is correct.....Any help/ideas?

Replies