https://community.qlik.com/t5/Talend-Studio/Passing-MySQL-Stored-Procedure-parameter-value/m-p/2319634#M89855 Hi, <BR /> 1) use an TSO Input component where you need to define a schema; and define a schema according to the input structure in the input component.. <BR /> 2) use tMySqlSP component and connect to the already placed input component; and mention the stored procedure name needs to be called in the "SP Name" of tMySqlSP component apart from declaring the other database credentials. <BR />3) select one or many defined field in the schema as parameter ( in the tMySqlSP component). select the type of parameter as Input/output etc. Define the stored procedure on the database also. <BR />This is for calling a stored procedure from TSO job. <BR />But your question looks like little different like calling TSO job from stored procedure. Is it this you need to do? <BR />Hope it helps <BR />Thanks and Regards, <BR />Pravu Mishra. Thu, 10 Sep 2009 06:59:53 GMT Anonymous 2009-09-10T06:59:53Z https://community.qlik.com/t5/Talend-Studio/Passing-MySQL-Stored-Procedure-parameter-value/m-p/2319633#M89854 Before I get too deep into troubleshooting this issue <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> <BR />When you create a stored procedure in mysql and have a parameter to pass (a date for example), how <BR />do you collect that parameter in TOS? In a software app I realize you'd collect the data value of an object and <BR />pass it on the method call. How does TOS handle getting that parameter value from the user at runtime? Sat, 16 Nov 2024 13:46:36 GMT https://community.qlik.com/t5/Talend-Studio/Passing-MySQL-Stored-Procedure-parameter-value/m-p/2319633#M89854 Anonymous 2024-11-16T13:46:36Z https://community.qlik.com/t5/Talend-Studio/Passing-MySQL-Stored-Procedure-parameter-value/m-p/2319634#M89855 Hi, <BR /> 1) use an TSO Input component where you need to define a schema; and define a schema according to the input structure in the input component.. <BR /> 2) use tMySqlSP component and connect to the already placed input component; and mention the stored procedure name needs to be called in the "SP Name" of tMySqlSP component apart from declaring the other database credentials. <BR />3) select one or many defined field in the schema as parameter ( in the tMySqlSP component). select the type of parameter as Input/output etc. Define the stored procedure on the database also. <BR />This is for calling a stored procedure from TSO job. <BR />But your question looks like little different like calling TSO job from stored procedure. Is it this you need to do? <BR />Hope it helps <BR />Thanks and Regards, <BR />Pravu Mishra. Thu, 10 Sep 2009 06:59:53 GMT https://community.qlik.com/t5/Talend-Studio/Passing-MySQL-Stored-Procedure-parameter-value/m-p/2319634#M89855 Anonymous 2009-09-10T06:59:53Z