Oracle Timer ____oracle



No output parameters:

Declare
Jobno number;
Begin
Dbms_job.submit (
Jobno,
What => ' sp_alert_info; '--sp_dayend as the name of the stored procedure
--interval => ' TRUNC (sysdate) + 1 + 17/(24) '--Define time interval
Interval => ' TRUNC (sysdate, ' mi ') + 10/(24*60) '
);
Commit
End

There are output parameters:

Declare
Jobno number;
Begin
Dbms_job.submit (
Job => Jobno,
What => ' declare v_errorcode number;v_errordesc varchar (sp_mer_sync), begin p_workdate => To_char YyyyMMdd '),
P_errorcode => V_errorcode,
P_errordesc => V_errordesc)
; End; ',--Sp_mer_sync is the name of the stored procedure
--interval => ' TRUNC (sysdate) + 1 + 17/(24) '--Define time interval
Interval => ' TRUNC (sysdate+1) + 05/(24) '
);
Commit
End

Check

Select Job,last_date,last_sec,next_date,next_sec,broken,failures from Dba_jobs;