Re: Jobno in dbms_job.submit

Md Irfan wrote:
>
> Hello,
> How does Oracle creates a job number for dbms_job.submit. Or we have
> to declare our own job number?
>
> Thanks.

Its just a sequence - automatically given to you by Oracle. If you pass a parameter into your job called 'JOB' you can reference the job number from within the job itself

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."