-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|