https://communities.sas.com/t5/SAS-Programming/Schedule-a-program-written-in-T-SQL/m-p/666518#M199443 <P>The T-SQL code should be run inside an explicit pass-through query.</P> <P>The SAS code that encapsulates the native SQL code can then be scheduled as any other SAS code.</P> <P>The connection parameters should specify which database the code is running against.&nbsp;</P> <P>&nbsp;</P> Thu, 02 Jul 2020 21:45:06 GMT ChrisNZ 2020-07-02T21:45:06Z https://communities.sas.com/t5/SAS-Programming/Schedule-a-program-written-in-T-SQL/m-p/666381#M199370 <P>I realy don't know the answer and need to reach out to a broader audience for help.&nbsp;</P><P>&nbsp;</P><P>One of Our SAS users has a piece of code written in T-SQL. He wants us to Schedule it on SAS server. What can be pros and cons here? What to expect?&nbsp;</P><P>&nbsp;</P><P>For some databases we are using a availability Groups, and when some of the users run queries agains these databases using pass-though, users will be routed to the wrong instance and Lock the database.&nbsp;</P> Wed, 01 Jul 2020 13:59:14 GMT https://communities.sas.com/t5/SAS-Programming/Schedule-a-program-written-in-T-SQL/m-p/666381#M199370 irinaia 2020-07-01T13:59:14Z https://communities.sas.com/t5/SAS-Programming/Schedule-a-program-written-in-T-SQL/m-p/666518#M199443 <P>The T-SQL code should be run inside an explicit pass-through query.</P> <P>The SAS code that encapsulates the native SQL code can then be scheduled as any other SAS code.</P> <P>The connection parameters should specify which database the code is running against.&nbsp;</P> <P>&nbsp;</P> Thu, 02 Jul 2020 21:45:06 GMT https://communities.sas.com/t5/SAS-Programming/Schedule-a-program-written-in-T-SQL/m-p/666518#M199443 ChrisNZ 2020-07-02T21:45:06Z