1.有kettle在win环境已经编写完成***.ktr,直接命令编写start.sh命令如下:
#!/bin/bash
datename=$(date +%Y%m%d-%H%M%S)
/opt/ETL/data-integration/pan.sh -file=/opt/ETL/kettle_file/***.ktr >> /opt/ETL/kettle_logs/jhqpt_log_$datename.log
2.使用crontab -e,编写定时每三分钟定时执行
*/3 * * * * cd /opt/ETL/start.sh
3.报错信息:
-
#######################################################################
-
WARNING: no libwebkitgtk-1.0 detected, some features will be unavailable
-
Consider installing the package with apt-get or yum.
-
e.g. 'sudo apt-get install libwebkitgtk-1.0-0'
-
####################################################################
-
很神奇,我直接命令运行start.sh可以允许,定时执行竟然报错;
查了很多资料大概错误原因有环境变量问题、路径问题;
最终解决办法:crontab -e
*/3 * * * * cd /opt/ETL && ./start.sh
sh命令修改为
#!/bin/bash
. /etc/profile
. ~/.bash_profile
datename=$(date +%Y%m%d-%H%M%S)
/opt/ETL/data-integration/pan.sh -file=/opt/ETL/kettle_file/***.ktr >> /opt/ETL/kettle_logs/jhqpt_log_$datename.log