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

13 votes318 views4 answers
Mysql select last 10 rows
SQL
0 vote333 views1 answer
Sql server union if table exist
SQL
0 vote339 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote319 views1 answer
Dnsmasq.conf location macos
SQL
2 votes327 views1 answer
Get hour from date sql
SQL
0 vote344 views1 answer
Compare subqueries oracle
SQL
50 votes409 views6 answers
Install mysql on ubuntu
SQL
0 vote329 views1 answer
Mysql update table from select on another table
SQL
0 vote344 views1 answer
Name '_mysql' is not defined
SQL
8 votes343 views10 answers
Sql
SQL