dev_Job与KTR文件路径:
cd ~/kettle/data-integration/data
执行路径:cd ~/kettle/data-integration
Linux启动ktr:
./pan.sh -file=data/test1.ktr >> data/log/test.log &
Linux启动Job:
./kitchen.sh -file = data/job2.kjb >> data/log/job2.log &
实例:【执行路径:cd ~/kettle/data-integration】
KIDO:
./pan.sh -file=data/kido.ktr >> data/log/kido.log &
./pan.sh -file=biz_user.ktr >> data/biz_user.log &
biz、Kido:【注意:需将Job与ktr放至同一层文件夹下】
./kitchen.sh -file data/job/bizAndKido.kjb >>data/log/bizAndKido.log &
【首先添加权限:chmod +x *.sh】
sh ~/kettle/data-integration/kitchen.sh -file data/job/bizAndKido.kjb >>data/log/bizAndKido.log &
sh ~/kettle/data-integration/kitchen.sh -file data/kido/kido.kjb >>data/log/kido.log &
资源库:
sh kitchen.sh -rep=kettle -user=admin -pass=admin -dir=/BI_ODS/biz -job=biz_job -level=Basic
日志打印至log
sh kitchen.sh -rep=kettle -user=admin -pass=admin -dir=/BI_ODS/biz -job=biz_job -level=Basic >> ~/kettle/data/logs/biz_job.log &
【shell脚本】
新增shell
vi kido.sh
shell内容:
#!/bin/sh
export JAVA_HOME=/usr/local/app/jdk1.8.0_66
export LANG=en_US.UTF-8
echo “kido-start”
cd ~/kettle/data-integration
echo “cd-------”
sh kitchen.sh -file data/kido/kido.kjb >>data/log/kido.log &
echo “end------------”
定时:【每天凌晨 零点30分同步】
30 0 * * * sh ~/kettle/shell/kido.sh >> ~/kettle/shell/kido.log &