Sql

Search

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;
/

Comment

PREVIOUS	NEXT

Code Example
Sql :: cloudformation deploy sqs example
Sql :: how to insert a ROWGUIDCOL into a table
Sql :: sql cmd no truncate
Sql :: get the next column of a table in mysql
Sql :: ALV GRID events
Sql :: resullt all update knex mysql
Sql :: psql check if sql script is valid
Sql :: shell script to log mysql cpu usage
Sql :: stored procedure function relation
Sql :: 9999
Sql :: min varias colunas spark sql
Sql :: rollback to name in sql
Sql :: mysql procedure between two tables
Sql :: tsql create table with variable name
Sql :: How Much Space is PL/Scope Data Using?
Sql :: How to take sum of column with same id in "JPQL?"
Sql :: Sql testing queries
Sql :: undefined get_magic_quotes_gpc() in sqlite
Sql :: tsql table column constraint must be uppercase
Sql :: sql script to get a type task on jira datbase for 12 months
Sql :: distinct
Sql :: oracle exchange partition
Sql :: postgres call view
Sql :: create sql table
Sql :: Pattern matching alternative sql
Sql :: sql date range
Sql :: Call to undefined function mysql_query() in D:xampphtdocsimageindex.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
Sql :: SQL create table full of dates
Sql :: insert random values in rows postgres
Sql :: SQL Cut part string

Search

SQL

procedure excute monthly oracle

ADD CONTENT