02-15-2013 12:29 PM
We are trying to implement a solution where we would like to restrict the user accessing the sas tables during a certain time period(due to lock out issue) when our processes are running and loading those tables.
What would be the best way to implement this?
02-15-2013 02:18 PM
Tough problem. One way might be to have the process that loads the tables change the permissions on the files or directories to only allow that process access and then change it back at the end.
If the user has the file(s) open before the time window starts, I don't know of anything to do except to use the OS to kill the SAS and EG processes.
02-17-2013 02:16 PM
One option that would be worth considering is to have one workspace server for production jobs and another for EG users. In SAS Management Console you can stop the Workspace Server for EG users while your production Workspace Server continues running.
Stopping the server will stop EG users either connecting to or running any jobs on your SAS server so it is very much a sledgehammer solution.... You can also stop a workspace server via a program if you want to do it automatically.
02-18-2013 10:47 AM
Thanks @Doc and @SASKiwi.
We do plan to kill all the SAS and EG processes before starting the batch jobs.
Will look at both the options provided and implement the feasible option.