An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Hi Danny,Please see attached document.RegardsMo
Hi Danny,Please see attached document.RegardsMo ------------------------------Mahmoud AbdolrahimSenior Implementation & Integration EngineerDatawatch CorporationMA(978) 935-3840-------------------------------------------------------------------------Original Message:Sent: 06-01-2019 05:32 PMFrom: Danny ValenzuelaSubject: Execute a SQL Store Procedure in ScriptHi,I am having such a hard time trying to figure out how to connect to a SQL Server and execute a stored procedure.I am using Monarch Automator 15.3. I added a Script to the Visual process but there isn't any good tutorials that I can find to do this.Any help is much appreciated.Thanks,------------------------------Danny ValenzuelaSenior Database Administrator------------------------------"
Hi Mo,This is a very useful script that we were looking for. I have one question - instead of calling a stored procedure that has no output, can we call a SQL function (or direct Select from the table) that will return exactly one value - "select dbo.f_getBusinessDate()" and stored it in the Automator global variable. Then we can use this variable throughout all processes that need to insert data into different tables using business date, rather then calendar date.Thank you,Leonid------------------------------Leonid ShteyngardtApp Dev ManagerCanaccord Genuity Inc.New York NY(212) 389-8176-------------------------------------------------------------------------Original Message:Sent: 06-02-2019 09:23 PMFrom: Mahmoud AbdolrahimSubject: Execute a SQL Store Procedure in ScriptHi Danny,Please see attached document.RegardsMo ------------------------------Mahmoud AbdolrahimSenior Implementation & Integration EngineerDatawatch CorporationMA(978) 935-3840------------------------------Original Message:Sent: 06-01-2019 05:32 PMFrom: Danny ValenzuelaSubject: Execute a SQL Store Procedure in ScriptHi,I am having such a hard time trying to figure out how to connect to a SQL Server and execute a stored procedure.I am using Monarch Automator 15.3. I added a Script to the Visual process but there isn't any good tutorials that I can find to do this.Any help is much appreciated.Thanks,------------------------------Danny ValenzuelaSenior Database Administrator------------------------------"
Hi Mo,This is a very useful script that we were looking for. I have one question - instead of calling a stored procedure that has no output, can we call a SQL function (or direct Select from the table) that will return exactly one value - "select dbo.f_getBusinessDate()" and stored it in the Automator global variable. Then we can use this variable throughout all processes that need to insert data into different tables using business date, rather then calendar date.Thank you,Leonid------------------------------Leonid ShteyngardtApp Dev ManagerCanaccord Genuity Inc.New York NY(212) 389-8176-------------------------------------------------------------------------Original Message:Sent: 06-02-2019 09:23 PMFrom: Mahmoud AbdolrahimSubject: Execute a SQL Store Procedure in Script
Hi Leonid,Attached document provides an example of executing a TSQL function. In this example I used one of the Monarch Server Automator User Defined functions, which returns the current Automator version number, and assign it to a global variable.RegardsMo------------------------------Mahmoud AbdolrahimSenior Implementation & Integration EngineerDatawatch CorporationMA(978) 935-3840-------------------------------------------------------------------------Original Message:Sent: 06-06-2019 07:34 AMFrom: Leonid ShteyngardtSubject: Execute a SQL Store Procedure in ScriptHi Mo,This is a very useful script that we were looking for. I have one question - instead of calling a stored procedure that has no output, can we call a SQL function (or direct Select from the table) that will return exactly one value - "select dbo.f_getBusinessDate()" and stored it in the Automator global variable. Then we can use this variable throughout all processes that need to insert data into different tables using business date, rather then calendar date.Thank you,Leonid------------------------------Leonid ShteyngardtApp Dev ManagerCanaccord Genuity Inc.New York NY(212) 389-8176------------------------------Original Message:Sent: 06-02-2019 09:23 PMFrom: Mahmoud AbdolrahimSubject: Execute a SQL Store Procedure in ScriptHi Danny,Please see attached document.RegardsMo ------------------------------Mahmoud AbdolrahimSenior Implementation & Integration EngineerDatawatch CorporationMA(978) 935-3840Original Message:Sent: 06-01-2019 05:32 PMFrom: Danny ValenzuelaSubject: Execute a SQL Store Procedure in ScriptHi,I am having such a hard time trying to figure out how to connect to a SQL Server and execute a stored procedure.I am using Monarch Automator 15.3. I added a Script to the Visual process but there isn't any good tutorials that I can find to do this.Any help is much appreciated.Thanks,------------------------------Danny ValenzuelaSenior Database Administrator------------------------------"
Hi Leonid,Attached document provides an example of executing a TSQL function. In this example I used one of the Monarch Server Automator User Defined functions, which returns the current Automator version number, and assign it to a global variable.RegardsMo------------------------------Mahmoud AbdolrahimSenior Implementation & Integration EngineerDatawatch CorporationMA(978) 935-3840-------------------------------------------------------------------------Original Message:Sent: 06-06-2019 07:34 AMFrom: Leonid ShteyngardtSubject: Execute a SQL Store Procedure in ScriptHi Mo,This is a very useful script that we were looking for. I have one question - instead of calling a stored procedure that has no output, can we call a SQL function (or direct Select from the table) that will return exactly one value - "select dbo.f_getBusinessDate()" and stored it in the Automator global variable. Then we can use this variable throughout all processes that need to insert data into different tables using business date, rather then calendar date.Thank you,Leonid------------------------------Leonid ShteyngardtApp Dev ManagerCanaccord Genuity Inc.New York NY(212) 389-8176------------------------------Original Message:Sent: 06-02-2019 09:23 PMFrom: Mahmoud AbdolrahimSubject: Execute a SQL Store Procedure in Script
How do I download or view the file How to run a Stored procedure in Automator Visual Process.docx?
Hi Matt,
Please see attached file.
Mo
If you click on the attached file it will be downloaded to the default download folder.