Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Accessing Job Log file in the Job/Trans

  1. #1

    Default Accessing Job Log file in the Job/Trans

    Hi, searched the forum, but could not find any help.

    Aim: If a job fails due to a set database-error, it should just start again.

    Plan: If the job fails, parse the logfile for certain SQL errors.
    If logfile contains them, start the Job again.

    Problem: Is there a way I can access the filename of the Log, that has been specified on the command-line "... /dir:/ /job:JOB2 /logfile:LOG_JOB2_20113009.txt "?
    Could not find anything Variable in the "Get System Info" Step.

    Any input would help, thanks
    Thorsten

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    If you specify a log-file in a Transformation job entry, the filename will be part of the result files list, tagged with a Log type.
    So a "Get files from result" step in a subsequent transformation gives you the filename.

    Easier still: simply ask for the log text: http://www.ibridge.be/?p=181

  3. #3

    Default

    Thank you Matt, it works great.

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.