topic scheduler and PHP script in Talend Studio

scheduler and PHP script

Anonymous — Sat, 16 Nov 2024 14:21:44 GMT

Hi everyone!
I would like to know if the following is possible, and how can I do this.
(?) I have a job that populates a DB table with data from another DB.
I also have a PHP script that does some calculations and updates with data from the table populated with the previous job.
Since my job will run on a schedule (using the scheduler), I was wondering if it was possible to maybe do something like:
onSubJob OK (referring to the population job I created) run the PHP script I have.
(?) Or maybe if somehow I could run this PHP script using just the scheduler, after I run my first job.
Long ago I managed to do this on MS SQL Server 2000 and asp scripts, but I migrated to open source and need to schedule some jobs!!!!
Thanks!!!! 😕

Re: scheduler and PHP script

Anonymous — Thu, 22 May 2008 04:00:20 GMT

Hello

onSubJob OK (referring to the population job I created) run the PHP script I have.

Does the tSystem component fix your need? tSystem can execute one or more system commands.
onSubJobOk-->tSystem(run PHP script)
About the usage of tSystem component, please read the user documentation.
Aslo read 2704.
Best regards

shong

Re: scheduler and PHP script

Anonymous — Thu, 22 May 2008 22:10:51 GMT

I'll give it a try and let you know!!!!!
Thanks!

Re: scheduler and PHP script

Anonymous — Thu, 22 May 2008 22:58:25 GMT

This worked just perfectly!!!! Thank you very much!

Re: scheduler and PHP script

Anonymous — Sun, 29 Jun 2014 00:21:44 GMT

I want to run a php script through tsystem and I also to need to pass multiple context variable to that php script. Can you tell me how can i do that ?