Hi,

I have tried the following:

exec DBMS_JOB.SUBMIT(:jobno,'proc;',sysdate,'sysdate+1/5600');

and it get executed successfully and proc also has been executed once. In user_jobs table there is entry for this job and next_date value also been set.

But, this procedure has not been executed next time.

I have tried to start the job by

exec DBMS_JOB.run(jobno); and
exec DBMS_JOB.interval(jobno,'sysdate+1/5600');

but there is no success.

please suggest the solution to run thejob in the interval.

thanks,
satheesh.