topic Re: Schedule Process Flow in SAS Enterprise Guide

Schedule Process Flow

deleted_user — Fri, 01 Sep 2006 23:17:12 GMT

How do I schedule a process flow to run repeatedly?

Re: Schedule Process Flow

ChrisHemedinger — Thu, 07 Sep 2006 19:39:51 GMT

Right-click on the flow in the Project Explorer and select Schedule .

That will interface with the Windows Scheduler and create a script file to automate EG to run.

Chris

Re: Schedule Process Flow

deleted_user — Thu, 26 Oct 2006 21:36:37 GMT

How do I schedule it to run on the server?

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?

Re: Schedule Process Flow

deleted_user — Thu, 26 Oct 2006 22:03:31 GMT

Here's what I'm getting when I try to run command-line:
sas mycode.sas

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
loaded.
0509-022 Cannot load module libclntsh.a(shr.o).
0509-026 System error: A file or directory in the path name does not
exist.
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.

Re: Schedule Process Flow

ChrisHemedinger — Mon, 30 Oct 2006 21:58:33 GMT

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.

Chris