DB

API

Manager

1. Job Manager 화면을 관리자(ROLE_SCH_ADMIN) 에게만 권한 부여

   • index.jsp 수정
   • jsp/1/history.jsp 수정
   • jsp/1/metadata.jsp 수정
   • jsp/1/metahistory.jsp 수정
   • jsp/1/servermgr.jsp 수정

2. Manager Job 목록조회 쿼리 오류 수정
   첫번째는 수정 전이고, 두번째는 수정 후 쿼리임

   select A.SCHEDULER_NAME as "SCHEDULER_NAME", A.MANAGER_NAME as "MANAGER_NAME", A.JOB_NAME as "JOB_NAME", A.JOB_GROUP as "JOB_GROUP", B.STATUS as "STATUS"
   from SCHEDULE_MANAGER_JOBS A, SCHEDULE_JOB_INFO B
   where A.SCHEDULER_NAME=:SCHEDULER_NAME and A.MANAGER_NAME=:MANAGER_NAME
   and A.JOB_NAME = B.JOB_NAME and A.JOB_GROUP = B.JOB_GROUP
   

   select B.SCHEDULER_NAME as "SCHEDULER_NAME", A.MANAGER_NAME as "MANAGER_NAME", A.JOB_NAME as "JOB_NAME", A.JOB_GROUP as "JOB_GROUP", B.STATUS as "STATUS"
   from SCHEDULE_MANAGER_JOBS A, SCHEDULE_JOB_INFO B
   where B.SCHEDULER_NAME=:SCHEDULER_NAME and A.MANAGER_NAME=:MANAGER_NAME
   and A.JOB_NAME = B.JOB_NAME and A.JOB_GROUP = B.JOB_GROUP
   

   • query/quartz-meta-manage-query.glue_sql 수정
   • mysql/quartz-meta-manage-query.glue_sql 수정
   • postgresql/quartz-meta-manage-query.glue_sql 수정

3. Job History 페이지 진입시 자동조회되지 않도록 처리

   • history.jsp 수정

Server

1. log purge job ( JobKey : _hidden_._hidden_ ) 동시수행 방지 적용 ( @DisallowConcurrentExecution Annotation 추가 )

   • com.poscoict.app.quartz.GlueHiddenJobImpl.java 수정

2. 쿼리 조건 변경 ( status not in -> status in )
   첫번째는 수정 전이고 두번째는 수정 후 쿼리임

   <query id="cm.job.history.vetoJobExecution.check" desc="" resultType="" isNamed="true"><![CDATA[
   select HISTORY_ID,JOB_NAME,JOB_GROUP from SCHEDULE_JOB_HISTORY where HISTORY_ID<:HISTORY_ID and STATUS not in ('STOPPED','ERROR','COMPLETE','MISFIRED') and SERVER_ADDR=:SERVER_ADDR
   ]]></query>
   

   <query id="cm.job.history.vetoJobExecution.check" desc="" resultType="" isNamed="true"><![CDATA[
   select HISTORY_ID,JOB_NAME,JOB_GROUP from SCHEDULE_JOB_HISTORY where HISTORY_ID<:HISTORY_ID and STATUS in ('STANDBY','FIRED','STARTING','RUNNING') and SERVER_ADDR=:SERVER_ADDR
   ]]></query>
   

   • com.poscoict.app.quartz.job-history-query.glue_sql 수정

3. log purge job 의 default 주기 변경 (매일 새벽3시 -> 매분 정각)

   • com.poscoict.app.quartz.GlueSchedulerQuartzUtil.java 수정