Monday, March 9, 2015

Sample scheduler job

BEGIN
  SYS.DBMS_SCHEDULER.DROP_JOB
    (job_name  => 'WGPCCWUSR.EFFICIENT_DRIVER_MONTHLY');
END;
/

BEGIN
  SYS.DBMS_SCHEDULER.CREATE_JOB
    (
       job_name        => 'WGPCCWUSR.EFFICIENT_DRIVER_MONTHLY'
      ,start_date      => TO_TIMESTAMP_TZ('2014/11/20 21:00:00.202697 US/Pacific','yyyy/mm/dd hh24:mi:ss.ff tzr')
      ,repeat_interval => 'FREQ=MONTHLY'
      ,end_date        => NULL
      ,job_class       => 'DEFAULT_JOB_CLASS'
      ,job_type        => 'PLSQL_BLOCK'
      ,job_action      => 'BEGIN EFFICIENT_DRIVER(); END;'
      ,comments        => 'EFFICIENT_DRIVER_MONTHLY'
    );
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'WGPCCWUSR.EFFICIENT_DRIVER_MONTHLY'
     ,attribute => 'RESTARTABLE'
     ,value     => FALSE);
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'WGPCCWUSR.EFFICIENT_DRIVER_MONTHLY'
     ,attribute => 'LOGGING_LEVEL'
     ,value     => SYS.DBMS_SCHEDULER.LOGGING_OFF);
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL
    ( name      => 'WGPCCWUSR.EFFICIENT_DRIVER_MONTHLY'
     ,attribute => 'MAX_FAILURES');
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL
    ( name      => 'WGPCCWUSR.EFFICIENT_DRIVER_MONTHLY'
     ,attribute => 'MAX_RUNS');
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'WGPCCWUSR.EFFICIENT_DRIVER_MONTHLY'
     ,attribute => 'STOP_ON_WINDOW_CLOSE'
     ,value     => FALSE);
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'WGPCCWUSR.EFFICIENT_DRIVER_MONTHLY'
     ,attribute => 'JOB_PRIORITY'
     ,value     => 3);
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL
    ( name      => 'WGPCCWUSR.EFFICIENT_DRIVER_MONTHLY'
     ,attribute => 'SCHEDULE_LIMIT');
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'WGPCCWUSR.EFFICIENT_DRIVER_MONTHLY'
     ,attribute => 'AUTO_DROP'
     ,value     => FALSE);

  SYS.DBMS_SCHEDULER.ENABLE
    (name                  => 'WGPCCWUSR.EFFICIENT_DRIVER_MONTHLY');
END;
/

No comments:

Post a Comment

Featured Post

Apply Patch 22191577 latest GI PSU to RAC and DB homes using Opatch auto or manual steps

Patch 22191577: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.160119 (JAN2016) Unzip the patch 22191577 Unzip latest Opatch Version in or...