vim /data/azkaban/exec/job/test.sh
shell脚本内容,
#!/bin/bash
set -e
configfile="$1"
while read -r line ; do
eval "$line"
done < $configfile
path=data
name=ads_ub_pv_uv_ip_cnt
sed "s/yesterday/$yesterday/g" /$path/azkaban/exec/job/$name.sql > /$path/azkaban/exec/job/$name_temp.sql
PGPASSWORD=$password psql -h $ip -U $username -d huayu -p 5432 -a -f /$path/azkaban/exec/job/$name_temp.sql
#以下代码就是希望azkaban返回执行结果的关键代码
A=$?
if [ $A == 0 ]
then
echo "执行成功!!哈哈"
else
echo "执行失败!!异常"
exit 1
fi
rm /$path/azkaban/exec/job/$name_temp.sql
在azkaban里调度配置.
job文件
type=command
command=sh /data/azkaban/exec/job/ads_brt_base_all_cnt.sh /data/azkaban/exec/job/configlie.properties