You need to sign in to do that
Don't have an account?
Data Loader and Windows Scheduler
I've configured the data loader to run in batch mode using the command line interface. I am excuting my process bean from the command line using the syntax below. No problems worked as I expected.
C:\Program Files\salesforce.com\Apex Data Loader 17.0\bin>process ../conf Extract_Accounts_NRT_BatchProcess
I now want to automate this process using a Windows Scheduler task to kick off the process. My scheduled task never runs because I assume my Run: syntax is incorrect. I've tried the following combinations without success. Any ideas of the correct sytnax I should use to kick off the process bean using a Windows Scheduler task?
"C:\Program Files\salesforce.com\Apex Data Loader 17.0\bin\process.bat" Extract_Accounts_NRT_BatchProcess
process.bat "C:\Program Files\salesforce.com\Apex Data Loader 17.0\bin" Extract_Accounts_NRT_BatchProcess
I didnt follow your recommendation exactly but it got me thinking and created something very similar. I create a .bat file that resides in the data loader bin directory using the below which kicks off the process.bat from the Windows Scheduler.
call process ../conf Extract_Accounts_NRT_BatchProcess
Thanks!
All Answers
Create a single batch file to put in Windows Scheduler
The content of the batch file should be something like that:
cd C:\Program Files\salesforce.com\Apex Data Loader 17.0\bin
process ../conf Extract_Accounts_NRT_BatchProcess
Try the batch file by itself before using it in the scheduler.
I didnt follow your recommendation exactly but it got me thinking and created something very similar. I create a .bat file that resides in the data loader bin directory using the below which kicks off the process.bat from the Windows Scheduler.
call process ../conf Extract_Accounts_NRT_BatchProcess
Thanks!
Hi,
How to solve this issue. how to schedule the commandline dataloader for inserting the record. can you please tell me in detail if possible.
Thanks,
Lakshmi.
Hi nagalakshmi,
Please follow these steps
Step 1: Create a batch file in "bin" folder of dataloader
The batch file should contain the following
"cls
call process "Path to the config.properties file" <bean id from process.conf file>
cls
call process "Path to the config.properties file" <bean id from process.conf file>"
Step 2: Open "Scheduled Task" from "System Tools"
Step 3: click "Add scheduled Task"
Step 4: Browse for the Batch file you just created and choose the frequency of batch execution like "daily, weekly,monthly " etc
Step 5: give the PC password if your system is password protected and click the fibish button.
Thats it you can executethe batch process.
Hope this might help :-)