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 vote103 views1 answer
Uncomment listen_address=localhost
SQL
0 vote100 views1 answer
Mariadb cast null to 0
SQL
0 vote95 views1 answer
Oracle list dblink
SQL
19 votes105 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote108 views1 answer
How to get button for every record from mysql
SQL
0 vote92 views1 answer
SQL SELECT-Klausel
SQL
0 vote104 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote109 views1 answer
How to display value of variable in mysql
SQL
16 votes99 views6 answers
Mysql find and replace
SQL
2 votes102 views1 answer
Oracle sql merge
SQL