第69和70次：远程作业2014-11-22

botang

1. select  * from dba_scheduler_credentials;
   
2. 
   
3. begin
   
4.   dbms_scheduler.create_credential(
   
5.         credential_name => 'credlocalfw',
   
6.         username => 'oracle',
   
7.         password => 'oracle');
   
8. end;
   
9. 
   
10. grant execute  on credlocalfw  to hr;
    
11. 
    
12. begin
    
13.    dbms_scheduler.create_file_watcher(
    
14.        file_watcher_name => 'filewlocal',
    
15.        directory_path => '/home/oracle/dirfw',
    
16.        file_name => 'botang*.txt',
    
17.        credential_name => 'credlocalfw');
    
18. end;
    
19. 
    
20. 
    
21. ----------------------------------
    
22. 
    
23. select  * from dba_scheduler_file_watchers;
    
24. 
    
25. grant execute on filewlocal to hr;
    
26. 
    
27. 
    
28. grant execute on SYS.SCHEDULER_FILEWATCHER_RESULT   to hr;
    
29. grant create external job to hr;
    
30. grant create job to hr;
    
31. 
    
32. create table hr.tfilewlocal    ( a  varchar2(200)  ) ;  
    
33. 
    
34. create or replace procedure hr.procfilewlocal ( p_1   SYS.SCHEDULER_FILEWATCHER_RESULT)
    
35. is
    
36. begin
    
37.   insert into     tfilewlocal   values ( to_char( p_1.file_timestamp,'YYYY-MM-DD:HH24:MI:SS') ||'      '
    
38.                                                       ||p_1.directory_path||'        '
    
39.                                                       ||p_1.actual_file_name||'       '
    
40.                                                       ||p_1.file_size  ) ;
    
41.   commit;
    
42. end;
    
43. 
    
44. 
    
45. begin
    
46.     dbms_scheduler.create_program(
    
47.      program_name => 'HR.progfilewlocal',
    
48.      program_type => 'STORED_PROCEDURE',
    
49.      program_action => 'HR.procfilewlocal',
    
50.      number_of_arguments => 1,
    
51.      enabled => false);
    
52. end;
    
53. 
    
54. begin
    
55.    dbms_scheduler.define_metadata_argument(
    
56.    program_name => 'HR.progfilewlocal',
    
57.    metadata_attribute => 'event_message',argument_position => 1 ) ;
    
58. end;
    
59. 
    
60. begin
    
61.   dbms_scheduler.enable('HR.progfilewlocal');
    
62. end;
    
63. 
    
64. begin
    
65.    dbms_scheduler.set_attribute('hr.jobfilewlocal','parallel_instances',true);
    
66. end;
    
67. 
    
68. 
    
69. 
    
70. select  * from  hr.tfilewlocal ;
    

复制代码

1. alter system set dispatchers='(PROTOCOL=TCP) (dispatchers=6)';
   
2. 
   
3. 
   
4. 
   
5. select  * from dba_users  order by 1;
   
6. 
   
7. BEGIN
   
8. DBMS_XDB.SETHTTPPORT(8888);
   
9. END;
   
10. 
    
11. SQL> @?/rdbms/admin/prvtrsch.plb
    
12. 
    
13. 
    
14. 
    
15. 
    
16. BEGIN
    
17. DBMS_SCHEDULER.SET_AGENT_REGISTRATION_PASS('mypassword');
    
18. END;
    
19. 
    
20. SELECT DBMS_XDB.GETHTTPPORT() FROM DUAL;
    
21. 
    
22. 
    
23. DECLARE
    
24. versionnum VARCHAR2(30);
    
25. BEGIN
    
26. versionnum := DBMS_SCHEDULER.GET_AGENT_VERSION('192.168.0.199');
    
27. DBMS_OUTPUT.PUT_LINE(versionnum);
    
28. END;
    
29. 
    
30. 
    
31. 
    
32. select  * from dba_scheduler_db_dests;
    
33. 
    
34. select  * from dba_scheduler_external_dests;
    

复制代码