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 vote140 views1 answer
Mssql now diff 90 day
SQL
4 votes143 views1 answer
Find tables with column name in sql
SQL
0 vote125 views1 answer
Dasebase_url-postgres for windows
SQL
7 votes142 views1 answer
Set sequence value oracle
SQL
6 votes152 views2 answers
Difference between join vs union
SQL
0 vote126 views1 answer
Group by 15 minute interval sql server
SQL
0 vote140 views1 answer
Access mysql database docker container shell
SQL
9 votes190 views3 answers
Pyodbc connect to sql server
SQL
6 votes144 views1 answer
Oracle trigger after logon on schema
SQL
0 vote144 views1 answer
Mysql reset wp_options
SQL