dsjob -server 10.190.34.150 -user dsadm -password 1qaz2wsx -lprojects | while read line
do
dsjob -server 10.190.34.150 -user dsadm -password 1qaz2wsx -jobinfo $line Q_Business_CashFlow_Query
if [ $? -eq 0 ] ; then
echo $line
break
fi
done
 

执行shell,命令如上,查询名字叫Q_Business_CashFlow_Query的dsjob所在的位置

调用dsjob命令

filepath="/EDWETL/EDW_QL/EDWQL_P/data/"
dbuser="at_pc_2009"
dbpasswd="atpc2009"
dsname="EDW_41.48"
condition=""
dsjob -server 10.190.35.77 -user dsadm -password 1qaz2wsx -run -mode NORMAL -wait -warn 0 -param filepath=$filepath \
  -param dbuser=$dbuser -param dbpasswd=$dbpasswd -param dsname=$dsname -param condition="$condition" EDW_QL p_ds_35_77