Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB submitted, but doesn't run?
OK, never mind again - this has not been my best day - I was running it in one instance, looking at the table in another, too many d*mn windows open!
Sorry,
Harry
On Thu, 25 Sep 2003 17:04:00 -0500, Harry Boswell <NOhboswel1SPAM_at_bellsouth.net> wrote:
>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:12:03 CDT