政府机关 商业智能
Datastage的Job调度不稳定的问题
在使用datastage时，定时调度Job，发现有时候回出现job已终止的现象，导致job执行失败。只能重新编译job再次运行。
请问这个问题是什么原因，该如何解决？
求大神指导
请问这个问题是什么原因，该如何解决？
求大神指导
11 同行回答
可以使用shell执行job。这样就可以做很多判断了。看这个是否对你有帮助。http://www.cognoschina.net/club/viewthread.php?tid=36953&extra=
#If the job still runing,stop it;
#If job state is not finished ok,then reset the job.
jobsta=$($DSHOME/bin/dsjob -jobinfo $projectName $jobName 2>&1 | awk -F: '/^Job
Status/{print $2}')
echo 'last status: ' $jobsta
if [ "$jobsta" == " RUNNING (0)" ];then
echo "Stop before run job $jobname"
$DSHOME/bin/dsjob -stop $projectName $jobName >>${logdir}/job_stop_` date
+%Y%m%d`.log
sleep 20
fi
if [ "$jobsta" == " RUN FAILED (3)" -o "$jobsta" == " STOPPED (97)" -o "$jobsta" == " CRASHED
(96)" ];then
echo "Reset before run job $jobname"
$DSHOME/bin/dsjob -run -mode RESET $projectName $jobName >>${logdir}/job_init_`
date +%Y%m%d`.log
sleep 10
fi 收起
#If the job still runing,stop it;
#If job state is not finished ok,then reset the job.
jobsta=$($DSHOME/bin/dsjob -jobinfo $projectName $jobName 2>&1 | awk -F: '/^Job
Status/{print $2}')
echo 'last status: ' $jobsta
if [ "$jobsta" == " RUNNING (0)" ];then
echo "Stop before run job $jobname"
$DSHOME/bin/dsjob -stop $projectName $jobName >>${logdir}/job_stop_` date
+%Y%m%d`.log
sleep 20
fi
if [ "$jobsta" == " RUN FAILED (3)" -o "$jobsta" == " STOPPED (97)" -o "$jobsta" == " CRASHED
(96)" ];then
echo "Reset before run job $jobname"
$DSHOME/bin/dsjob -run -mode RESET $projectName $jobName >>${logdir}/job_init_`
date +%Y%m%d`.log
sleep 10
fi 收起