분류 전체보기213 centos / openjdk [root@localhost ~]# yum list java*jdk-devel Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * base: centos.mirror.cdnetworks.com * extras: centos.mirror.cdnetworks.com * updates: centos.mirror.cdnetworks.com Available Packages java-1.6.0-openjdk-devel.x86_64 1:1.6.0.41-1.13.13.1.el7_3 base java-1.7.0-openjdk-devel.x86_64 1:1.7.0.171-2.6.13.0.el7_4 updates java-1.8.0-open.. 2020. 4. 19. linux / centos7 / hostname [root@localhost ~]# hostname localhost.localdomain [root@localhost ~]# set-hostname ABCD -bash: set-hostname: command not found [root@localhost ~]# [root@localhost ~]# hostnamectl set-hostname ABCD [root@localhost ~]# [root@localhost ~]# hostname abcd [root@localhost ~]# ssh재접속시 적용됨 2020. 4. 19. oracle / job / batch 참고 : https://docs.oracle.com/database/121/ARPLS/d_job.htm#ARPLS66560 1. 신규등록 DBMS_JOB.SUBMIT( job OUT BINARY_INTEGER, what IN VARCHAR2, next_date IN DATE DEFAULT SYSDATE, interval IN VARCHAR2 DEFAULT 'NULL', no_parse IN BOOLEAN DEFAULT FALSE, instance IN BINARY_INTEGER DEFAULT ANY_INSTANCE, force IN BOOLEAN DEFAULT FALSE ); ex) DECLARE job NUMBER; BEGIN DBMS_JOB.SUBMIT(job --자동생성 , 'DBMS_OUTPUT... 2020. 4. 17. oracle / dbms_scheduler 1. 조회 SELECT * FROM user_scheduler_jobs; SELECT * FROM dba_scheduler_jobs; SELECT NEXT_RUN_DATE,REPEAT_INTERVAL, a.* FROM user_scheduler_jobs a; ---신규 생성후 NextRunData , RepeatInterval 확인 2. 권한부여 grant create any job to 유저명 ; 2. 신규등록 begin dbms_scheduler.create_job( -- 신규 JOB을 생성 job_name => 'insert_job_test1' , -- dbms_scheduler 내에서 사용될 job 이름지정 job_type => 'plsql_block' , -- 5번줄에 적은 프로그램의 타입을 적.. 2020. 4. 17. 이전 1 ··· 42 43 44 45 46 47 48 ··· 54 다음 반응형