Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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!!!! 😕
Labels (2)
4 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

I'll give it a try and let you know!!!!!
Thanks!
Anonymous
Not applicable
Author

This worked just perfectly!!!! Thank you very much!
Anonymous
Not applicable
Author

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 ?