Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1. BEGIN
  2. SYS.DBMS_SCHEDULER.CREATE_JOB
  3. (
  4. job_name => 'SYS.POB_TB_JOB'
  5. ,start_date => TO_TIMESTAMP_TZ('2019/02/10 00:05:00.000000 America/New_York','yyyy/mm/dd hh24:mi:ss.ff tzr')
  6. ,repeat_interval => 'FREQ=DAILY;BYDAY=MON,TUE,WED,THU,FRI,SAT,SUN'
  7. ,end_date => NULL
  8. ,job_class => 'DEFAULT_JOB_CLASS'
  9. ,job_type => 'STORED_PROCEDURE'
  10. ,job_action => 'SELLER.FILL_TB_S1'
  11. ,comments => NULL
  12. );
  13.  
  14. SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
  15. ( name => 'SYS.POB_TB_JOB'
  16. ,attribute => 'MAX_RUN_DURATION'
  17. ,value => TO_DSINTERVAL('+000 05:00:00'));
  18.  
  19. SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
  20. ( name => 'SYS.POB_TB_JOB'
  21. ,attribute => 'number_of_arguments'
  22. ,value => 4);
  23.  
  24. SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE
  25. ( job_name => 'SYS.POB_TB_JOB'
  26. ,argument_position => 1
  27. ,argument_value => '30');
  28.  
  29. SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE
  30. ( job_name => 'SYS.POB_TB_JOB'
  31. ,argument_position => 2
  32. ,argument_value => 'N');
  33.  
  34. SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE
  35. ( job_name => 'SYS.POB_TB_JOB'
  36. ,argument_position => 3
  37. ,argument_value => 'N');
  38.  
  39. SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE
  40. ( job_name => 'SYS.POB_TB_JOB'
  41. ,argument_position => 4
  42. ,argument_value => '1');
  43.  
  44. SYS.DBMS_SCHEDULER.ENABLE
  45. (name => 'SYS.POB_TB_JOB');
  46. END;
  47. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement