Hitachi Vantara Pentaho Community Forums
Results 1 to 8 of 8

Thread: how to get job start from system infos?

  1. #1
    Join Date
    Aug 2007
    Posts
    25

    Unhappy how to get job start from system infos?

    hi,
    i try to get "start of date range" from the system infos and put it in an table in a db. but there is nothing...
    is there anything what i do wrong?

    please help

    best regards
    s

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Start of date range will check the log table. The first time you run a transformation it will be 1900 as start date. It's explained at http://kettle.pentaho.org/tips/?tip=9

    What about "system date (variable)"?

    Regards,
    Sven
    Last edited by sboden; 08-08-2007 at 04:55 AM.

  3. #3
    Join Date
    Aug 2007
    Posts
    25

    Default

    sorry, i am talking abut start job date range(this is the part that not works), not start trans date range, this works....

    regards

  4. #4
    Join Date
    Jul 2007
    Posts
    247

    Default

    I'm afraid it's a bug... Try to design a job that runs a transformation. In that transformation use Get System Info to get the job start date range.

    The field for the job start date range will always be empty if you run the transform via the job...

    Regards,
    Ben

  5. #5
    Join Date
    Aug 2007
    Posts
    25

    Default

    Quote Originally Posted by BeLienig View Post
    I'm afraid it's a bug... Try to design a job that runs a transformation. In that transformation use Get System Info to get the job start date range.

    The field for the job start date range will always be empty if you run the transform via the job...

    Regards,
    Ben
    so i have to put a bug tracker?

    regards
    s

  6. #6
    Join Date
    May 2006
    Posts
    4,882

    Default

    Benjamin, Sebastian,

    Attached a transformation/job... It works for me. Can you adapt the attached example so that it fails for you, then we have something to test against.

    Regards,
    Sven
    Attached Files Attached Files

  7. #7
    Join Date
    Jul 2007
    Posts
    247

    Default

    Misunderstanding... It works fine with the transformation start range but fails with the job date start range.

    See my example for details.
    Attached Files Attached Files

  8. #8
    Join Date
    May 2006
    Posts
    4,882

    Default

    Bug tracker created at http://jira.pentaho.org/browse/PDI-25 ... feel free to add information to it

    Regards,
    Sven

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.