KETTLE命令行执行JOB（*.KJB）

最新推荐文章于 2023-07-16 15:18:05 发布

gisinfo

最新推荐文章于 2023-07-16 15:18:05 发布

阅读量8k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/gisinfo/article/details/8535041

本文详细介绍了如何在命令行环境下使用Kettle执行JOB（.KJB）文件，适用于自动化任务调度，通过实例演示配置及执行过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

--前提
Windows环境+正确的环境变量配置+kettle版本信息（4.3）
--从资料库中运行区分大小写
kitchen /rep etl /user admin /pass admin /job Job_ETL
--从文件中运行
kitchen /file:D:\\ETL\\file_job.kjb /level:Basic
--定期执行

计划任务的建立可以参见Python章节

--详细参数
C:\Users\gyh>kitchen
DEBUG: Using JAVA_HOME
DEBUG: _PENTAHO_JAVA_HOME=D:\Program Files\Java\jdk1.6.0_33
DEBUG: _PENTAHO_JAVA=D:\Program Files\Java\jdk1.6.0_33\bin\java.exe
Options:
  /rep            : Repository name
  /user           : Repository username
  /pass           : Repository password
  /job            : The name of the job to launch
  /dir            : The directory (dont forget the leading /)
  /file           : The filename (Job XML) to launch
  /level          : The logging level (Basic, Detailed, Debug, Rowlevel, Error,Nothing)
  /logfile        : The logging file to write to
  /listdir        : List the directories in the repository
  /listjobs       : List the jobs in the specified directory
  /listrep        : List the available repositories
  /norep          : Do not log into the repository
  /version        : show the version, revision and build date
  /param          : Set a named parameter <NAME>=<VALUE>. For example -param:FOO=bar
  /listparam      : List information concerning the defined parameters in the specified job.
  /export         : Exports all linked resources of the specified job. The argument is the name of a ZIP file.
  /maxloglines    : The maximum number of log lines that are kept internally by Kettle. Set to 0 to keep all rows (default)
  /maxlogtimeout  : The maximum age (in minutes) of a log line while being kept internally by Kettle.
	        Set to 0 to keep all rows indefinitely (default)