Scheduling jobs to import data
On the BMC Communities website, the Pentaho packages for importing data from external data sources into BMC Remedyforce page contain a Scheduling Files folder. This folder contains a sample batch file that you can use as a base to create your batch files for scheduling data import. For more information about scheduling a job, see http://wiki.Pentaho.com/display/EAI/Kitchen+User+Documentation.
- Navigate to the folder where you have extracted the Pentaho package for which you want to schedule import jobs.
- Open the Scheduling Files folder and create a copy of the sample batch file, such as SchedulingComputerSystem.bat.
- Open the batch file that you created in step 2, and perform the following actions:
- Update the path of the Kitchen.bat file based on your version of the Pentaho Data Integration tool:
KETTLE_HOME="<path>\<PentahoInstallerFolder>\data-integration"
For example:KETTLE_HOME="C:\pdi-ce-6.1.0.1-196\data-integration
"
- Update the path of the Kitchen.bat file and the KJB file:
<path>\<PentahoInstallerFolder>
\data-integration\kitchen.bat /file:"<JobFile>\<JobFileName>.kjb"/level:Detailed
- <path> is the location where you have extracted the Pentaho installer ZIP file.
- <PentahoInstallerFolder> is the extracted root folder for your version of the Pentaho Data Integration tool.
For example: For version 6.1 of the Pentaho Data Integration Tool, the extracted root folder ispdi-ce-6.1.0.1-196.
- <JobFile> is the location where you have extracted the job files.
- <JobFileName> is the KJB file that you want to run at the scheduled interval.
- The level option specifies the level of logging for the job. The values that you can specify for the level option are Minimal, Basic, Detailed, Debugging, and Row Level. The log files are saved in the same folder where KJB files are saved.
- Update the path of the Kitchen.bat file based on your version of the Pentaho Data Integration tool:
- Go to Start > Control Panel > Administrative Tools > TaskScheduler.
- In the Task Scheduler window, in the Actions area, click Create Basic Task.
- In the Create Basic Task Wizard, type the name and description of the task, and click Next.
- Select the appropriate option for starting the task, and click Next.
For example, you can select Daily or When the computer starts as the option for starting the task. - Configure the additional options for starting the task, and click Next.
The additional options are displayed based on the option that you selected in step 8. For example, if you select the Daily option for starting the task, you must configure the start date and frequency at which you want to run the batch file. - Select the Start a program radio button, and click Next.
- Click Browse to locate the batch file that you have created to schedule the job, and click Next.
- Select the Open the Properties dialog for this task when I click Finish check box, and click Finish.
Related topics
Importing data from BMC Atrium Discovery
Importing data from BMC Atrium CMDB
Was this page helpful? Yes No
Submitting...
Thank you
Comments
Log in or register to comment.