Re: Jobno in dbms_job.submit

"Md Irfan" <irfan_pk_at_hotmail.com> wrote in message news:c42168e7.0206200554.6fd81ff4_at_posting.google.com...
> Hello,
> How does Oracle creates a job number for dbms_job.submit. Or
we have
> to declare our own job number?
>
> Thanks.

Oracle does this for you.

To submit a job e.g.

DECLARE
j NUMBER;
BEGIN dbms_job.submit(j,'wd_ctx_utils.sweep;',interval=>'sysdate+1/720 ');
  dbms_output.put_line('Job# is '||j);
END;
/

--
jeremy