Thursday, 15 September 2011

Can not find schedule perspective in pentaho kettle spoon -



Can not find schedule perspective in pentaho kettle spoon -

hello guys i'm using kettle spoon 5.0.1 , can't find schedule perspective, or other except info integration perspective, can help me, please?

if need scheduling in ce, have yourself. fortunately isn't terribly hard. utilize external scheduler launch transforms , jobs via pan , kitchen.

for example, utilize pgagent since have postgresql. set schedules , launch job follows:

set kettle_password=encrypted (some pwd) "c:\program files\pentaho\daily_jobs.bat" > "c:\program files\pentaho\daily_jobs.log"

and daily_jobs.bat this:

cd /d "c:\program files\pentaho\" kitchen.bat /rep:"etl_prod" /job:"daily jobs" /dir:"/finished" /user:brian /level:basic

this runs job "daily jobs" in "/finished" directory of pdi repository utilize "brian" basic logging , using password stored in kettle_password. these windows batch files, .sh scripts in linux work well. no don't have in 2 separate batch files (i forget why did originally).

while utilize pgagent, scheduler can launch batch files/shell scripts should work.

pentaho kettle perspective spoon

No comments:

Post a Comment