Which user to schedule job/flow in SAS Viya Environment Manager

[pviland]

Hi all, 

Recently scheduled a job to run in batch with a personal user in SAS Environment Manager in Viya, Job scheduler. When this user left the company and the user was deactivated, the jobs did not execute any longer. 

My immediate idea was to have a shared-user that will always exist, to schedule it with, but with regards to GDPR, and version-control it is not recommended. 

Any ideas/best practices?

//Peder

[sbxkoenk]

Hello,

I'm a consultant / statistician without much experience with Admin & Deploy, but I know that you can set up the SAS system to work with a service account (as from VIYA 3.5).
See here:

SAS Viya 3.5 Compute Server Service Accounts
Posted 01-29-2020 04:08 PM | by StuartRogers
https://communities.sas.com/t5/SAS-Communities-Library/SAS-Viya-3-5-Compute-Server-Service-Accounts/...

All users are sassrv then , and hence also the jobs they schedule.

%PUT &=sysuserid;
SYSUSERID=sassrv

This is a very practical solution, but you may run into problems (?) whenever you try to enable for 'Row Level Security' as all users are sassrv.

Koen

[SASKiwi]

I would suggest a service account that is only used for Viya scheduling. I think it would be dangerous to use an existing SAS installation service account as they will likely need different permissions and require usage to be tracked separately.