topic Re: sas jobs failure in prod environment in SAS Programming

sas jobs failure in prod environment

justusjillella — Sun, 10 Mar 2019 01:26:39 GMT

Hi Guys, can anyone share some of the examples for why a sas job fails in production environment from their experience?

Patrick — Sun, 10 Mar 2019 01:33:51 GMT

For the same reasons that it would fail in any other environments. Things like:

- Syntax error

- Out of resources (memory, disk)

- File locking (i.e. EG session locking a SAS table)

- Missing permissions (i.e. SAS user trying to read/write to folder location but not having the required permissions)

- Refused connections (required SAS or DBMS server down)

- Network dropouts

- Virus scanner interfering (can for example result in "random" file locked errors)

- ....

justusjillella — Sun, 10 Mar 2019 14:01:42 GMT

Thank you.