Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB submitted, but doesn't run?
Do a commit as well, otherwise job executing process doesn't see it when scanning job$ table.
Tanel.
"Harry Boswell" <NOhboswel1SPAM_at_bellsouth.net> wrote in message
news:r7p6nv4o32okif0q3h9icbsq10df14g38m_at_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 - 18:11:27 CDT