Re: DBMS_JOB starting job

Hello
> When I create a job with SUBMIT and parameter NEXT_DATE=sysdate+(1/48)
> (starts in 30min.), and an interval of 30 min, the job never starts.
> The job is not broken.

Try put sysdate+(1/48) in quotes
example:
dbms_job.submit(jobno,'p_job_test;',sysdate,'sysdate+1/(24*60)');

it should work propely

regards

--
Tomek
--
+48 608 687 708
http://tomek.mga.com.pl