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
    Posts
    13

    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
    Posts
    4,683

    Default

    End your Job with a Mail step.
    You can define it to send mail only on Fail too.
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    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.