活动第47/48次（2018-08-11星期六上下午）

botang

作业组：

1. DECLARE
   
2.     versionnum VARCHAR2(30);
   
3.     BEGIN
   
4.     versionnum := DBMS_SCHEDULER.GET_AGENT_VERSION('station86');
   
5.     DBMS_OUTPUT.PUT_LINE(versionnum);
   
6.     END;
   
7.    
   
8.     select  * from dba_scheduler_external_dests;
   
9.    
   
10. 
    
11.    
    
12.   BEGIN
    
13.   DBMS_SCHEDULER.create_group(
    
14.     group_name    => 'hr.group1',
    
15.     group_type    => 'EXTERNAL_DEST',
    
16.      member => 'sys.credential1@LOCAL,sys.credential1@sys.STATION86'
    
17.     );
    
18. END;
    
19. 
    
20. select  * from dba_scheduler_groups g where g.group_name='GROUP1';
    
21. select  * from dba_scheduler_group_members gm where gm.group_name='GROUP1';
    
22. 
    
23. grant all on group1 to hr;
    

复制代码

界面点出来的代码：

1. BEGIN
   
2. sys.dbms_scheduler.create_job(
   
3. job_name => '"HR"."JOB14"',
   
4. job_type => 'EXECUTABLE',
   
5. job_action => '/home/oracle/helloworld.sh',
   
6. repeat_interval => 'FREQ=SECONDLY;INTERVAL=30',
   
7. start_date => systimestamp at time zone 'Asia/Shanghai',
   
8. end_date => to_timestamp_tz('2018-08-11 10:00:00 Asia/Shanghai', 'YYYY-MM-DD HH24:MI:SS TZR'),
   
9. job_class => '"DEFAULT_JOB_CLASS"',
   
10. comments => 'JOB14',
    
11. auto_drop => FALSE,
    
12. enabled => FALSE);
    
13. DBMS_SCHEDULER.SET_ATTRIBUTE(name => '"HR"."JOB14"', attribute => 'destination', value => 'HR。GROUP1' );
    
14. DBMS_SCHEDULER.SET_ATTRIBUTE(name => '"HR"."JOB14"', attribute => 'credential_name', value => '"SYS"."CREDENTIAL1"' );
    
15. sys.dbms_scheduler.enable( '"HR"."JOB14"' );
    
16. END;

复制代码

改成：

1. BEGIN
   
2. sys.dbms_scheduler.create_job(
   
3. job_name => '"HR"."JOB14"',
   
4. job_type => 'EXECUTABLE',
   
5. job_action => '/home/oracle/helloworld.sh',
   
6. start_date => systimestamp at time zone 'Asia/Shanghai',
   
7. end_date => to_timestamp_tz('2018-08-11 10:00:00 Asia/Shanghai', 'YYYY-MM-DD HH24:MI:SS TZR'),
   
8. job_class => '"DEFAULT_JOB_CLASS"',
   
9. comments => 'JOB14',
   
10. auto_drop => FALSE,
    
11. credential_name =>'"SYS"."CREDENTIAL1"' ,destination_name =>'HR.GROUP1' ,
    
12. enabled => true);
    
13. END;

复制代码