scheduler and PHP script

One Star

scheduler and PHP script

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!!!! :/
Community Manager

Re: scheduler and PHP script

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: scheduler and PHP script

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

Re: scheduler and PHP script

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

Re: scheduler and PHP script

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 ?