oracle dbms job


DECLARE
   JOBNO   NUMBER;
BEGIN
   DBMS_JOB.SUBMIT
      (JOB  => JOBNO
      ,WHAT => 'BEGIN PROCEDURE_NAME; END;'
      ,NEXT_DATE => SYSDATE
      ,INTERVAL  => 'SYSDATE+365');
   COMMIT;

END;

DBMS_JOB.submit: 등록
DBMS_JOB.remove: 삭제
DBMS_JOB.change: 변경
DBMS_JOB.next_date: 다음 JOB 실행시간
DBMS_JOB.interval: 실행 Cycle
DBMS_JOB.what: 프로시저 변경
DBMS_JOB.run: 수동 실행

Popular posts from this blog

com.gpki.secureweb.GPKISecureWEBException: ErrCode=1507,ErrMsg=[GPKI_CMS_ProcessEnvelopedData] 해당 인증서로는 데이터를 풀 수 없습니다.

om.gpki.secureweb.GPKISecureWEBException: ErrCode=1507,ErrMsg=[GPKI_CMS_ProcessEnvelopedData] 해당 인증서로는 데이터를 풀 수 없습니다. at com.gpki.servlet.GPKIHttpServletRequest.init(GPKIHttpServletRequest.java:550) at com.gpki.servlet.GPKIHttpServletRequest.<init>(GPKIHttpServletRequest.java:134) at kr.go.elevator.com.user.web.ComUserController.actionCrtfctLogin(ComUserController.java:485) at sun.reflect.GeneratedMethodAccessor1601.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.doInvokeMethod(HandlerMethodInvoker.java:421) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:136) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:326) at org.springfr...
Read more

PL/SQL Developer Tip 선택한 것만 실행

Image
sql Window 에서 여러개의 쿼리가 있을경우 선택한 부분만 실행  -   Tool > Preferences > Window Types의 SQL Window 선택 > AutoSelect statement 체크 - 실행고자 하는 쿼리에 커서를 위치한 다음 'F8'로 실행하면 해당 쿼리만 실행됨.
Read more

전자정부 EgovMap Xml Jsp

<?xml version='1.0' encoding='utf-8'?> <%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <%@ page import="java.util.List,acdn.welvt.elvtr.service.ElvtrSpecVo"%> <%@ page import="egovframework.rte.psl.dataaccess.util.EgovMap" %> <web> <% List<EgovMap> troubleList = (List)request.getAttribute("troubleList");  System.out.println("jsp"); if (troubleList != null) { for (int i = 0; i < troubleList.size(); i++) { EgovMap pnMap = (EgovMap)troubleList.get(i); out.print("<trouble_detail>"); out.print("<trouble_sn>" +  pnMap.get("troubleSn")+ "</trouble_sn>"); out.print("<defect_dt>" + pnMap.get("defectDt") + "</defect_dt>"); out.print("<defect_type>" + pnMap.get("defectType") + "</def...
Read more