My approach is to export the process flow to SAS code, then run it from cron. The process I am trying to schedule includes a node that accesses data from an Oracle server -- I've been using SAS/Access to get to that data.
Do I need to hard-code the password into the SAS code?
Here's what I'm getting when I try to run command-line:
I configured LD_LIBRARY_PATH to point at the Oracle lib.
I get the following errors in the libname statement for the Oracle access library:
Could not load /SAS/SAS913/SAS_9.1/sasexe/sasora (49 images loaded)
Error: 0509-022 Cannot load module /SAS/SAS913/SAS_9.1/sasexe/sasora.
0509-150 Dependent module libclntsh.a(shr.o) could not be
0509-022 Cannot load module libclntsh.a(shr.o).
0509-026 System error: A file or directory in the path name does not
0509-022 Cannot load module /SAS/SAS913/SAS_9.1/sasexe/sasora.
0509-150 Dependent module
/SAS/SAS913/SAS_9.1/sasexe/sasora could not be loaded.
I'm taking a guess here, but I suspect that there are some oracle-enabling environment variables that are not being set when you run your SAS command.
When you run within EG, EG connects to a SAS session that is launched by the object spawner. The object spawner launches a SAS command that is, most likely, wrapped up in a shell script that sets some environment variables so that your SAS session can act as an Oracle client.
You'll probably want to contact tech support for help in figuring this one out.