PDI schedule 설정

스케쥴 관련 정보 DB저장 모습

INSERT INTO R_REPOSITORY_LOG VALUES(387,'3.0','2008-10-16 11:17:47.906000000','admin','save job ''sanghyuk Job''')
INSERT INTO R_JOB VALUES(2,0,'sanghyuk Job',NULL,NULL,NULL,0,-1,NULL,'admin','2008-06-03 21:16:09.000000000','admin','2008-10-16 11:17:47.890000000','Y','N','Y',NULL)
INSERT INTO R_JOBENTRY VALUES(3,2,10,'START','Special entries')
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(21,2,3,0,'start',0.0,'Y')
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(22,2,3,0,'dummy',0.0,'N')
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(23,2,3,0,'repeat',0.0,'Y')
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(24,2,3,0,'schedulerType',1.0,NULL)
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(25,2,3,0,'intervalSeconds',5.0,NULL)
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(26,2,3,0,'intervalMinutes',0.0,NULL)
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(27,2,3,0,'hour',12.0,NULL)
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(28,2,3,0,'minutes',0.0,NULL)
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(29,2,3,0,'weekDay',1.0,NULL)
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(30,2,3,0,'dayOfMonth',1.0,NULL)
INSERT INTO R_JOBENTRY_COPY VALUES(3,3,2,10,0,98,124,'Y','N')
INSERT INTO R_JOBENTRY VALUES(4,2,10,'DUMMY 1','Special entries')
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(31,2,4,0,'start',0.0,'N')
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(32,2,4,0,'dummy',0.0,'Y')
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(33,2,4,0,'repeat',0.0,'N')
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(34,2,4,0,'schedulerType',0.0,NULL)
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(35,2,4,0,'intervalSeconds',0.0,NULL)
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(36,2,4,0,'intervalMinutes',60.0,NULL)
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(37,2,4,0,'hour',12.0,NULL)
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(38,2,4,0,'minutes',0.0,NULL)
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(39,2,4,0,'weekDay',1.0,NULL)
INSERT INTO R_JOBENTRY_ATTRIBUTE VALUES(40,2,4,0,'dayOfMonth',1.0,NULL)
INSERT INTO R_JOBENTRY_COPY VALUES(4,4,2,10,0,200,124,'Y','N')
INSERT INTO R_JOB_HOP VALUES(2,2,3,4,'Y','Y','Y')

 

스케쥴링 관련 문서

http://wiki.pentaho.com/display/PentahoDoc/Scheduling