DBMS_JOB submitted, but doesn't run?

From: Harry Boswell <NOhboswel1SPAM_at_bellsouth.net>
Date: Thu, 25 Sep 2003 17:04:00 -0500
Message-ID: <r7p6nv4o32okif0q3h9icbsq10df14g38m@4ax.com>

I set up a test script to play with DBMS_JOB. Here's the BDMS_SUBMIT statements:

declare
 v_jobnum binary_integer;  

begin
 dbms_job.submit(v_jobnum, 'job1;', sysdate, 'sysdate + (1/(24*60*60))');  end;

and here's my test script:

CREATE OR REPLACE procedure job1
as

begin

insert into job_test

     (job_string, job_date)
 values ('Updated by DBMS_JOB',

                SYSDATE);

end;
/

The procedure compiled, and I can execute it. I see the job sitting in ALL_JOBS, but it doesn't execute as a scheduled job. Is there more to this than I've done thus far?

Thanks,
Harry Received on Thu Sep 25 2003 - 17:04:00 CDT