procedure excute monthly oracle
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'your_job_name',
job_type => 'STORED_PROCEDURE', -- see oracle documentation on types --
job_action => 'name of the procedure',
start_date => trunc(sysdate)+2/24, -- every night @ 2 a.m.
repeat_interval => 'FREQ=DAILY;BYHOUR=2', -- daily @ 2 a.m.
end_date => NULL,
enabled => TRUE,
comments => 'your general comment');
END;
/