How to Use tPrejob and tPostJob


How to Use tPrejob and tPostJob

tPrejob and tPostjob are great when you need execute given tasks, before and after your job. Unlike other components, these components do not process data and cannot be configured. They always execute, even if the main job fails, making them great for tasks that need to be completed even if the job is not successful.


Some scenarios in which you might need to use tPrejob include:

  • loading context information
  • logging the start of the job
  • ensuring that a file exists
  • creating a database connection

On the other hand, you might use tPostjob to:

  • delete any temporary files you created within the job
  • log the end of a job
  • close any connections that you may have created

These components are added to jobs the same way any other components are, simply click and drag them from the palette or search for them by clicking on the canvas. All you need to do after that is connect them to your subjob using an “OnComponentOk” connection. Bellow, is an example of tPrejob and tPostjob being utilized.




Re: How to Use tPrejob and tPostJob


Thanks for sharing it with us.

Best regards


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: How to Use tPrejob and tPostJob

Thanks for the post/information.

Just to be absolutely clear, the screen shot shown is BEFORE the OnComponentOk connections to the subjob have been added? The subjob being the employee to tMap to tFileOutputDelimited?

Or is the screen shot the "final" product?


Seven Stars

Re: How to Use tPrejob and tPostJob

Hello CygnusX1,


the screenshot shows the final job design. There is no connection from PreJob to the main subjob or from there to PostJob. The "employee" component has a green background, that means it is the start component of the main subjob (executed after PreJob and before PostJob).


Best regards,