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