Submit job (<10g)


<br />
DECLARE<br />
X NUMBER;<br />
BEGIN<br />
SYS.DBMS_JOB.SUBMIT<br />
( job => X<br />
,what => 'CAPSTONE.STATUS_ALERT;'<br />
,next_date => to_date('19.08.2008 15:40:00','dd/mm/yyyy hh24:mi:ss')<br />
,interval => 'SYSDATE+30/1440 '<br />
,no_parse => TRUE<br />
);<br />
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));<br />
END;<br />
/<br />

DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X 
,what => 'CAPSTONE.STATUS_ALERT;'
,next_date => to_date('19.08.2008 15:40:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'SYSDATE+30/1440 '
,no_parse => TRUE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
END;
/