Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Log all jobs/transformations run within a repository

  1. #1
    Join Date
    Apr 2009

    Default Log all jobs/transformations run within a repository

    Hi, I have a number of jobs/transformations that I have recently moved to a repository (PDI 4.1). I'm trying to figure out how to log execution results of all jobs/transformations in the repository to a MySQL database.

    It doesn't seem like there is an option to specify a single logging connection for a repository so I have tried doing it for each job individually. I've defined a log connection for the job and I've used the SQL button to generate the correct schema, however, I am getting an error when I try to save a job with a log connection defined - I think it is the same error as noted here.

    Any advice would be appreciated. I would also love to be able to send an e-mail when a transformation/job encountered an error, or if that's not possible, to just send an e-mail of the execution results of each transformation/job.

  2. #2
    Join Date
    Apr 2008


    End your Job with a Mail step.
    You can define it to send mail only on Fail too.
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

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.