2020. 7. 31. 10:01
카테고리 없음
declare
nlsvar varchar2(4000);
envvar raw(32);
begin
select distinct nls_env,misc_env into nlsvar,envvar
from dba_jobs
where
misc_env='0102000200000000' and
nls_env like 'NLS_LANGUAGE=''KOREAN''%' and job=582;
sys.dbms_ijob.submit
(
JOB=>700,
luser=>'유저이름', puser=>'유저이름',cuser=>'유저이름' ,
NEXT_DATE=>to_date('31-07-2020 10:10:00','dd/mm/yyyy hh24:mi:ss') ,
INTERVAL=> 'TRUNC(SYSDATE+1)+1/24+10/1440' ,
WHAT=> '--주석
--주석
--주석
OWNER.패키지.PROCEDURE(null,null);
OWNER.패키지.PROCEDURE;'
,broken=>FALSE
,nlsenv=>nlsvar
,env=>envvar
);
end;