Parameter TWO which is ur procedure name shld hv a semi-colon. That might be an error...
dbms_job.submit(:jobno,'trunc_table;','NEXT_DAY(TRUNC(SYSDATE), ''MONDAY'') + 6/24')
|
Results 1 to 6 of 6
Thread: Dbms_jobs.submitThreaded View
|
Click Here to Expand Forum to Full Width |