To invoke the kettle job periodically using the Windows Self-Task Scheduler manager

Source: Internet
Author: User
Tags add time

System platform: Windows system, other operating systems please refer to other information.

The scheduled Task Scheduler for Kettle is not stable, and you must turn on kettle to implement timed jobs through the Windows Task Scheduler calling Kettle Kitchen.bat.

Online to find some kitchen.bat parameters, but also smattering, no in-depth study.

Kitchen.bat back can be-also can be/then add options

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 =. 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.

The options can be followed by = or can be: spaces

Kitchen.bat/file D:\ or-file=d:\. or/file:d:\ and so on can ...

The following formally begins the creation of the calling scheme

1: Create a startup file to be called by Windows Task Scheduler

Create a new text file, rename it to "9 points daily", File right-click Edit, open it as a text file, and copy the contents below to save.

1 D:2CD D:\pdi-ce-6.0.0.0-353\data-Integration3kitchen.bat-rep:xxx-dir:/-job:"XXX"-user:xxx-pass:xxx-level:basic-log:d:\kettlebat\log\ daily 9-Point execution%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%.txt

Note: The first line D: to the third row of Kitchen.bat is open Kettle Kitchen.bat, the file is generally in the root directory of kettle, according to the actual save path modification.

-rep: After the XXX modified for the repository name,-job: After the XXX modified to perform the job name,-user: and-pass: After the xxx for the resource pool account password,

-level for log level, common Basic, detailed, Debug, Rowlevel, Error, nothing six levels, use basic here, other levels of self-testing,

Save the path for the log after-log, and%date and%time in the path add time to the log name when the log is created.

2: Add a task schedule
Right-click the computer or My computer, select Manage, select Task Scheduler. or open it in a different way, in short, open the Task Scheduler.

Click on the right side to create a basic task, enter a task name, click Next to set the trigger, click Next to set the specific trigger conditions, here can be set to a variety of scheduled tasks.

Click Next to set the operation as the launcher, then select the 9 points created above to execute. bat, then click Done.

In order to create basic tasks, the settings are relatively simple, the function is weak, it is recommended to create a task directly click Create Task, specify more reliable tasks, such as setting whether the user is logged on to run, set the number of restarts after the task failed, set the task time-out, and so on.

The main code comes from the predecessor Shinta, salute.

To invoke the kettle job periodically using the Windows Self-Task Scheduler manager

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.