sas jobs failure in prod environment

[justusjillella]

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

[Patrick · Accepted solution]

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]

Thank you.