procedure excute monthly oracle

Solutions on MaxInterview for procedure excute monthly oracle by the best coders in the world

Search
showing results for - "procedure excute monthly oracle"
Camilo
12 May 2017
1BEGIN                      
2  DBMS_SCHEDULER.CREATE_JOB ( 
3   job_name        => 'your_job_name',
4   job_type        => 'STORED_PROCEDURE',       -- see oracle documentation on types --
5   job_action      => 'name of the procedure',
6   start_date      => trunc(sysdate)+2/24,      -- every night @ 2 a.m.
7   repeat_interval => 'FREQ=DAILY;BYHOUR=2',    -- daily @ 2 a.m.
8   end_date        => NULL,
9   enabled         => TRUE,
10   comments        => 'your general comment');
11END;
12/
13
source
similar questions
oracle percentageoracle procedure dynamic sqloracle compile procedureoracle calculate statistics on partitionoracle synonym procedureoracle show proceduresoracle function returnexec procedure pl sqljob oracle exempleoracle create procedure exampletrigger oracle executionprocedure pl 2fsqloracle list grants on procedureprocedure plsqloracle show running procedureshow to get output from stored procedure in oracleoracle show execution planoracle running queriesexec procedure oracleoracle select partitionoracle step procedurepl 2fsql procedure exampleoracle list proceduresoracle create stored procedureoracle procedure as vs issql procedure oracleoracle procedure teamplatepl 2fsql procedure
queries leading to this page
procedure excute monthly oracleprocedure excute monthly oracle