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

1 vote272 views1 answer
Sql list all procedures
SQL
19 votes281 views4 answers
Rename database in sql
SQL
0 vote272 views1 answer
How to define a save method in ruby for sql databases
SQL
11 votes294 views1 answer
Oracle view source
SQL
0 vote286 views1 answer
Sql developer connect to sql server
SQL
1 vote306 views1 answer
Liquibase alter column type / length
SQL
0 vote299 views1 answer
Calculate age in sql
SQL
5 votes297 views1 answer
Sql add column after another
SQL
5 votes275 views3 answers
Day of week postgresql
SQL
0 vote279 views2 answers
How to delete the rows with null values in mysql
SQL