Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: automatic ETL run once system is restarted.

  1. #1
    Join Date
    Aug 2015
    Posts
    313

    Default automatic ETL run once system is restarted.

    Hi Sir,Madam,

    our environment is PDI 6.1, Windows, Java 1.7, MySQL and using Task scheduler for my scheduled ETL process.

    We are facing issue with scheduled ETL when system is restarting automatically based windows updates. here is the scenario.

    1. we scheduled ETL @ 2:00 AM in production environment and few times Windows is updating automatically and restarting respectively, on next day ETL is not taking care automatically.
    2. we manually starting the etl during this issue scenario.

    Seems to be automatic updates in Production environment is not correct approach so we disabled it. But we may be miss important system updates regarding security levels.

    my request is , is there way/steps to enable in Task scheduler i.e. ETL is able to run automatically once system is restarted ?

    is Wake the computer to run the task, is helpful for me ? in Task scheduler conditions tab

    Thanks,
    Santhi

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Looks like a Task Scheduler problem to me.


    Name:  230506.jpg
Views: 56
Size:  12.9 KB

  3. #3
    Join Date
    Aug 2015
    Posts
    313

    Default

    Thank you Marabu Sir.
    So i need to take care of it manually when system is restarted.

  4. #4
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    I didn't say that.

    My point is if the task is configured correctly, you shouldn't have to worry about system restarts.

  5. #5
    Join Date
    Aug 2016
    Posts
    142

    Default

    In the task properties, in the General tab you could also try selecting Run whether user is logged on or not. That coupled with what Marabu said should allow automatic execution after a restart (Marabu's suggestion is located in the Settings tab of the task)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.