Pentaho作业未通过运行批处理文件执行 [英] Pentaho job is not executing by running batch file

问题描述

我正在使用Windows框.我安装了PDI 6.0并创建了PDI作业.我创建了一个job.bat文件，当我尝试在Shell中执行作业时，该作业根本没有执行.但是通过使用Pentaho Spoon，这项工作可以很好地完成.我不知道为什么它不使用bat文件在Windows命令提示符下运行.这是我创建的批处理文件

I am using windows box. I installed PDI 6.0 and created a PDI job. I created a job.bat file and when I tried to execute the job in the shell, the job is not executing at all. But by using Pentaho Spoon, this job is totally working fine. I have no idea why it is not running in the windows command prompt using bat file. Here is the batch file I created

@echo off
cd D:\Pentaho\DataIntegration
SET WORK_DIR=D:\Work
SET LOG_FILE=%WORK_DIR%\log\job.log
SET JOB_FILE=%WORK_DIR%\PDI_JOB\job.kjb
SET DEV_SERVER=DEVDBSERVER
SET DEV_DB=devdb
SET DB_USER=dataadmin
SET DEV_DB_PWD=1HSFGD4426384VVJJKJCACACSFJWK
SET ENV=DEV
"D:\Pentaho\DataIntegration CE 6.0.1.0-386\Kitchen_6g.bat"   /file:%JOB_FILE% "-param:WORK_DIR=%WORK_DIR%" "-param:DEV_SERVER_LOCAL=%DEV_SERVER%" "-param:DEV_DB_RE=%DEV_DB%" "-param:DB_ADMIN_USER=%DB_USER%" "-param:DEV_DB_PWD_ADMIN=%DEV_DB_PWD%" /log:%LOG_FILE% /level:Detailed
@echo on'

我不知道此脚本有什么问题.如果有人可以指出，将不胜感激.

I have no idea what is wrong with this script. If anyone can point out, it will be very appreciated.

预先感谢

推荐答案

您可以尝试以下代码

@回声关闭

SET myparam = a123

SET myparam=a123

致电D:\ Development \ data-integration70 \ kitchen.bat/文件:D:\ opt \ CE \ data-integration \ weekly_data_transfer \ testenv.kjb"/param:TestParam =％myparam％"--level =最小>>"D:\ opt \ CE \ data-integration \ weekly_data_transfer \ log.log"

call D:\Development\data-integration70\kitchen.bat /file:D:\opt\CE\data-integration\weekly_data_transfer\testenv.kjb "/param:TestParam=%myparam%" --level=Minimal >> "D:\opt\CE\data-integration\weekly_data_transfer\log.log"

@echo on

这篇关于Pentaho作业未通过运行批处理文件执行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！