We are currently using SAS 9.1.3 on our platform and planning to migrate to 9.2 very soon. I wanted to make sure about something thats in place today will work when we switch over to the newer version. So here are the details -
We have a task in place where it calls SAS.exe via command line. Essentially there is a batch file with a piece of code looking like this -
There is a scheduled database job running on MS SQL Server 2005 that executes a batch file sitting locally on the DB server. Based on some criteria (I guess you can call it business logic), it runs the batch file. This local batch file then uses PSEXEC to remotely execute another batch file sitting on the SAS Server.
Yes, you can use the command you stated earlier, but be aware that you are not really running a stored process. What you are doing is executing the underlying SAS code in batch mode, under the userid that starts the process.
The success of this method depends on what the SAS code is doing.
We are researching ways to formally run stored processes, and may include that functionality in a future release.