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;
/

Source: stackoverflow.com

Similar codes

0 vote348 views1 answer
Show table details postgresql
SQL
3 votes374 views4 answers
Ubuntu stop mysql
SQL
0 vote331 views1 answer
Postpresql relation not found
SQL
0 vote360 views1 answer
Creation d'un trigger sql
SQL
5 votes345 views3 answers
Oracle list columns in schema
SQL
0 vote385 views1 answer
Mysql best varchar length size
SQL
5 votes308 views1 answer
Postgres upsert
SQL
-1 vote367 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
0 vote340 views2 answers
How to update date in oracle
SQL
0 vote398 views2 answers
Identity syntax in sql
SQL