Desktop productivity for business analysts and programmers

Schedule Process Flow

Reply
N/A
Posts: 0

Schedule Process Flow

How do I schedule a process flow to run repeatedly?
Community Manager
Posts: 2,712

Re: Schedule Process Flow

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
N/A
Posts: 0

Re: Schedule Process Flow

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?
N/A
Posts: 0

Re: Schedule Process Flow

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.
Community Manager
Posts: 2,712

Re: Schedule Process Flow

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
Ask a Question
Discussion stats
  • 4 replies
  • 208 views
  • 0 likes
  • 2 in conversation