Re: Job submitted via dbms_job, when does it first run?

In article <34c527c3.28626502_at_inet16>, Thomas Kyte <tkyte_at_us.oracle.com> writes
>On Fri, 16 Jan 1998 12:13:30 +0000, Andy Hardy <Andy_Hardy_at_camk.demon.co.uk>
>wrote:
>
>>From the available documentation, I thought that a job entered via
>>dbms_job would run immediately(ish) and then at the defined 'interval'.
>>
>>In practice, it appears that the job is only run for the first time when
>>you call dbms_job.run.
>>
>>Is this true, or am I experiencing local difficulties?
>>
>>Andy
>>NT4, OWS 7.3.3
>
>
>dbms_job.submit submits the job but does not commit. dbms_job.run does a commit
>(and hence would start the cycle for you).

Thanks. I guess that it should have percolated into my noddle that as the info is going into a table it needs to be committed!

Andy

-- 
Andy Hardy
Senior IT Systems Engineer
Cegelec AEG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions are mine and do not necessarily reflect those of Cegelec AEG