batch2 windows / batch script 날짜 date,time @echo off rem 날짜포맷만 가지고 변수로 지정 rem setlocal enableextensions rem 오전시간 시간이 1자리인경우 left "0" 추가 set hour=%time:~0,2% if "%time:~0,1%"==" " set hour=0%time:~1,1% set arcname1=%date:~0,4%%date:~5,2%%date:~8,2%%hour%%time:~3,2%%time:~6,2% rem YYYYMMDDHH24mi echo %arcname1% 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. 이전 1 다음 반응형