I've got a 1-line batch file that runs a pantaho etl job. It works fine when I run it from command line or gui, but the process doesn't even start when it's scheduled. I have the following settings:

-Run whether user is logged on or off (Do not store password is NOT checked)

-Run with highest privelages

-Trigger is set to 'daily' and 'Enabled' check box is active

-Action is 'Start a program'

-Program/script: The absolute location of my .bat file

-Add arguements is blank

-Start in is the folder where the file is located.

-Nothing is checked on the 'Conditions' tab

The history shows this, that the task goes through all steps in the same moment:

Level   Date and Time   Event ID    Task Category   Operational Code    
Information 6/10/2013 10:47:00 AM   102 Task completed  (2) 
Information 6/10/2013 10:47:00 AM   201 Action completed    (2) 
Information 6/10/2013 10:47:00 AM   129 Created Task Process    Info    
Information 6/10/2013 10:47:00 AM   200 Action started  (1) 
Information 6/10/2013 10:47:00 AM   100 Task Started    (1) 
Information 6/10/2013 10:47:00 AM   319 Task Engine received message to start task  (1) 
Information 6/10/2013 10:47:00 AM   107 Task triggered on scheduler Info    

The scheduler's history tells me the task has been successfully completed with return code of 1.

Thanks for any suggestions.

  • 1
    A return code of 1 means the task exited with a non-zero results - which usually means some kind of error occurred when the program ran. – martineau Jun 10 '13 at 15:08
  • @martineau, I've tested several times by running it from the command line and from the GUI. Success is reported and the database records are updated appropriately. – user1810434 Jun 10 '13 at 15:29
  • You say: "nothing is checked on the 'Conditions' tab" - try checking these two options: Start the task only of the computer is on AC power and Stop if the computer switches to battery power. I have those two checked and mine runs automatically. – Kevdog777 Jun 10 '13 at 15:52
  • Also, you don't need the Start in (optional) field (in Actions) - as the program will be set in the Programs/script field. – Kevdog777 Jun 10 '13 at 15:56
  • 1
    user1810434: I know that, I read your question. The point I was trying to make was that the program is encountering an error of some kind when run from the Task Scheduler. If you can figure out what that error is, then you may be able to correct it. – martineau Jun 10 '13 at 17:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.