|
- select * from v$circuit;
- select * from v$session where saddr in ( select saddr from v$circuit);
- select * from dba_users order by 1;
- SELECT DBMS_XDB.GETHTTPPORT() FROM DUAL;
- DECLARE
- versionnum VARCHAR2(30);
- BEGIN
- versionnum := DBMS_SCHEDULER.GET_AGENT_VERSION('192.168.0.79');
- DBMS_OUTPUT.PUT_LINE(versionnum);
- END;
- select * from dba_tab_privs t where t.grantee='HR';
- select * from dba_sys_privs s where s.grantee='HR';
- select * from dba_scheduler_external_dests;
- grant all on station79 to hr;
- select * from dba_tab_privs t where t.grantee='HR';
复制代码
-----------------------------job12
- select * from dba_scheduler_dests;
- select * from dba_scheduler_file_watchers;
- begin
- dbms_scheduler.create_file_watcher(
- file_watcher_name => 'filewatcher2',
- directory_path => '/home/oracle/yourfile',
- file_name => 'botang*.txt',
- credential_name => 'credential1',
- destination => 'STATION79');
- end;
- grant execute on filewatcher2 to hr;
- select * from hr.tfilewatcher1;
- create table hr.tfilewatcher2( a varchar2(200) ) ;
- create or replace procedure hr.procfilewatcher2( p_1 SYS.SCHEDULER_FILEWATCHER_RESULT)
- is
- begin
- insert into hr.tfilewatcher2 values ( to_char( p_1.file_timestamp,'YYYY-MM-DD:HH24:MI:SS') ||' '
- ||p_1.directory_path||' '
- ||p_1.actual_file_name||' '
- ||p_1.file_size ) ;
- commit;
- end;
- begin
- dbms_scheduler.create_program(
- program_name => 'HR.program12',
- program_type => 'STORED_PROCEDURE',
- program_action => 'HR.procfilewatcher2',
- number_of_arguments => 1,
- enabled => false);
- end;
- begin
- dbms_scheduler.define_metadata_argument(
- program_name => 'HR.program12',
- metadata_attribute => 'event_message',argument_position => 1 ) ;
- end;
- begin
- dbms_scheduler.enable('HR.program12');
- end;
- BEGIN
- DBMS_SCHEDULER.CREATE_JOB(
- jOB_NAME=> 'hr.job12',
- PROGRAM_NAME=> 'hr.program12',
- EVENT_CONDITION => 'tab.user_data.file_size > 10',
- QUEUE_SPEC=> 'filewatcher2',
- AUTO_DROP=> FALSE,
- ENABLED=> true);
- END;
- begin
- dbms_scheduler.set_attribute('hr.job12','parallel_instances',true);
- end;
- select * from hr.tfilewatcher2;
复制代码
--------------------请在rcat上做:
- SQL> create user hr identified by oracle_4U account unlock;
- User created.
- SQL> grant resource,connect to hr;
- Grant succeeded.
- SQL> create table hr.t05317_job13( a number ) ;
- Table created.
复制代码
造成以上的错误是由于幻灯片P35的set_attribute造成的:
- select * from dba_scheduler_credentials;
- begin
- dbms_scheduler.create_credential(credential_name => 'credential2',
- username => 'HR',
- password => 'oracle_4U');
- end;
-
- grant execute on credential2 to hr;
- select * from dba_scheduler_external_dests;
- begin
- dbms_scheduler.create_database_destination(destination_name => 'rcat_station79',
- agent =>'STATION79',tns_name => 'rcat');
- end;
- select * from dba_scheduler_db_dests;
- select * from dba_scheduler_dests;
- grant all on rcat_station79 to hr;
- BEGIN
- sys.dbms_scheduler.create_job(
- job_name => 'HR.JOB13',
- program_name => 'HR.PROGRAM13',
- schedule_name => 'HR.SCHEDULE13',
- credential_name => 'SYS.CREDENTIAL2',
- destination_name => 'SYS.RCAT_STATION79',
- enabled => true );
- <div>END;
- </div>
复制代码
- select * from dba_scheduler_groups;
- select * from dba_scheduler_group_members g
- where g.group_name='WINDOWGROUP1';
-
-
- select * from dba_scheduler_windows;
-
- select * from dba_scheduler_window_groups;
- BEGIN
- DBMS_SCHEDULER.create_group(
- group_name => 'hr.group1',
- group_type => 'DB_DEST',member => 'LOCAL,RCAT_STATION79'
- );
- END;
- BEGIN
- DBMS_SCHEDULER.create_group(
- group_name => 'hr.group2',
- group_type => 'EXTERNAL_DEST',member => 'sys.credential1@LOCAL,sys.credential1@STATION79'
- );
- END;
- BEGIN
- sys.dbms_scheduler.create_job(
- job_name => 'HR.JOB14',
- program_name => 'HR.PROGRAM14',
- schedule_name => 'HR.SCHEDULE14',
- credential_name => 'SYS.CREDENTIAL2',
- destination_name => 'HR.GROUP1',
- enabled => true );
- end;
- select * from dba_scheduler_groups;
复制代码
|
|