Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN
- SYS.DBMS_SCHEDULER.CREATE_JOB
- (
- job_name => 'SYS.POB_TB_JOB'
- ,start_date => TO_TIMESTAMP_TZ('2019/02/10 00:05:00.000000 America/New_York','yyyy/mm/dd hh24:mi:ss.ff tzr')
- ,repeat_interval => 'FREQ=DAILY;BYDAY=MON,TUE,WED,THU,FRI,SAT,SUN'
- ,end_date => NULL
- ,job_class => 'DEFAULT_JOB_CLASS'
- ,job_type => 'STORED_PROCEDURE'
- ,job_action => 'SELLER.FILL_TB_S1'
- ,comments => NULL
- );
- SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
- ( name => 'SYS.POB_TB_JOB'
- ,attribute => 'MAX_RUN_DURATION'
- ,value => TO_DSINTERVAL('+000 05:00:00'));
- SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
- ( name => 'SYS.POB_TB_JOB'
- ,attribute => 'number_of_arguments'
- ,value => 4);
- SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE
- ( job_name => 'SYS.POB_TB_JOB'
- ,argument_position => 1
- ,argument_value => '30');
- SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE
- ( job_name => 'SYS.POB_TB_JOB'
- ,argument_position => 2
- ,argument_value => 'N');
- SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE
- ( job_name => 'SYS.POB_TB_JOB'
- ,argument_position => 3
- ,argument_value => 'N');
- SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE
- ( job_name => 'SYS.POB_TB_JOB'
- ,argument_position => 4
- ,argument_value => '1');
- SYS.DBMS_SCHEDULER.ENABLE
- (name => 'SYS.POB_TB_JOB');
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement