This should work ...
Code:VARIABLE jobno number; Begin DBMS_Job.Submit ( job => :jobno, what => 'reset_nbr;', next => Trunc(SysDate,'MM')+(2/24), interval => 'Trunc(SysDate,'MM')+(2/24)' ); End; / Commit;
|
Results 1 to 5 of 5
Thread: Dbms_jobThreaded View
|
Click Here to Expand Forum to Full Width |