kettle小例子

crontab -l

0  11  *  *  * /home/xxy_hjlj/data-integration/kettle_code/shell/kettle_job.sh

[xxy_hjlj@ipcweb2 shell]$ vi kettle_job.sh 
/home/xxy_hjlj/data-integration/kettle_code/shell/fact_call_counts.sh
/home/xxy_hjlj/data-integration/kettle_code/shell/fact_province_victim.sh
/home/xxy_hjlj/data-integration/kettle_code/shell/fact_region_intercept.sh
/home/xxy_hjlj/data-integration/kettle_code/shell/fact_intercept_count.sh

[xxy_hjlj@ipcweb2 shell]$ vi  fact_intercept_count.sh

source /etc/profile

cd /home/xxy_hjlj/data-integration

yesterdayMonth=`date -d yesterday  +'%Y%m'`
yesterdayBegin=`date -d yesterday  +'%Y-%m-%d'`
echo $yesterdayMonth
echo $yesterdayBegin
echo $yesterdayEnd


sh kitchen.sh -file:/home/xxy_hjlj/data-integration/kettle_code/init_fact_intercept_count.kjb "-param:stat_month=$yesterdayMonth" "-param:stat_begin_time=$yesterdayBegin"