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

Note

To understand the job scheduling process, refer to the following procedure. This procedure is an example to be used as a reference for all other packages.

To schedule the Remedyforce LDAP Pentaho package to import users, perform the following steps:

(For all other required packages, perform these steps by using the respective batch files.)

Navigate to the Remedyforce Package folder.
Rename your extracted package folder to SchedulingFiles.
Open the folder where you have installed the Pentaho Data Integration tool and minimize this folder.
Open the SchedulingFiles folder.
The folder contains two .bat files.
To create a copy of the batch file, copy SchedulingTransferLDAPInfo.bat file and paste it in the same folder.
Right-click the SchedulingTransferLDAPInfo.bat file and click Edit.
The SchedulingTransferLDAPInfo.bat notepad opens.
Minimize the notepad and open the Pentaho data-integration folder as mentioned in Step 3.
Copy the data-integration folder address and navigate to the notepad as mentioned in Step 6.
The following figure shows an example of the updated SchedulingTransferLDAPInfo.bat file.
Before the first line of the notepad, type cd and paste the copied data-integration folder address . (Make sure to add a space betweeen cd and the folder address).
Paste the data-integration folder address in the Kettle Home folder address and remove the double quotes ("").
Paste the data-integration folder address in the kitchen.bat file address by replacing only the part before \kitchen.bat.
Navigate to the Remedyforce Package folder and copy the address for TransferLDAPInfo.kjb.
Paste the TransferLDAPInfo.kjb address in between \kitchen.bat /file: and /level:Detailed. Remove the double quotes ("") and any additional spaces between the address.
Save the notepad.

To prepare for scheduling

Open the Command Prompt as an administrator.
Type cd and then paste the SchedulingFiles folder address with a space in between the two.
Copy and paste the .bat file name (SchedulingTransferLDAPInfo.bat).
The job starts running.

To schedule the job

Go to Start > Control Panel > Administrative Tools > Task Scheduler.
In the Actions section, click Create Task.
In the General tab, enter the name and description.
Select the Run with highest privileges check box, and click OK.
On the Triggers tab, click New, select the appropriate option for starting the task, and click OK.
For example, you can select Daily or When the computer starts as the option for starting the task.
On the Actions tab, click New.
Click Browse, select SchedulingTransferLDAPInfo.bat, and click OK.

Scheduling jobs to import data

Related topics

Comments