DECLARE X NUMBER;
BEGIN
DBMS_JOB.SUBMIT
( job => X
,what => 'SP_ANALYZE_OBJECT;'
,next_date => trunc(add_months(last_day(sysdate)+2,0))+3/24
,interval => 'trunc(add_months(last_day(sysdate)+2,0))+3/24'
,no_parse => TRUE
);
END;
BEGIN
DBMS_JOB.SUBMIT
( job => X
,what => 'SP_ANALYZE_OBJECT;'
,next_date => trunc(add_months(last_day(sysdate)+2,0))+3/24
,interval => 'trunc(add_months(last_day(sysdate)+2,0))+3/24'
,no_parse => TRUE
);
END;