Try this...
variable jobno number;
begin
dbms_job.submit(:jobno,'trunc_table;','NEXT_DAY(TRUNC(SYSDATE), ''MONDAY'') + 6/24');
COMMIT;
END;
/
|
Results 1 to 6 of 6
Thread: Dbms_jobs.submitThreaded View
|
Click Here to Expand Forum to Full Width |