I.配置转换
II.配置数据源
II.配置输入输出
I.配置job
II.start>作业>success
I.调用job
#!/bin/bash
export JAVA_HOME=/usr/local/wdds/jdk1.6.0_45/
export PATH=$JAVA_HOME/bin:$PATH
export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
/usr/kettle/data-integration/kitchen.sh -file=/usr/kettle/job/bin/tf_film_job.kjb > /usr/kettle/job/log/log.txt
I.定时任务
crontab -e
23 17 * * * root sh /usr/kettle/job/bin/run.sh
II.配置数据源
II.配置输入输出
I.配置job
II.start>作业>success
I.调用job
#!/bin/bash
export JAVA_HOME=/usr/local/wdds/jdk1.6.0_45/
export PATH=$JAVA_HOME/bin:$PATH
export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
/usr/kettle/data-integration/kitchen.sh -file=/usr/kettle/job/bin/tf_film_job.kjb > /usr/kettle/job/log/log.txt
#!/bin/bash
export JAVA_HOME=/usr/local/wdds/jdk1.6.0_45/
export PATH=$JAVA_HOME/bin:$PATH
export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
/usr/kettle/data-integration/kitchen.sh -file=/usr/kettle/job/bin/tf_film_job.kjb > /usr/kettle/job/log/log.txt
I.定时任务
crontab -e
23 17 * * * root sh /usr/kettle/job/bin/run.sh
10 6 * * * sh /usr/kettle/job/bin/run.sh >> /usr/kettle/job/log/log.txt
I.导出成TXT有很多空格,windows下无问题,linux下有问题
解决方法1、更换编码;2、手工抽取时取消格式