BookmarkSubscribeRSS Feed
deleted_user
Not applicable
How do I schedule a process flow to run repeatedly?
4 REPLIES 4
ChrisHemedinger
Community Manager
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
It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
deleted_user
Not applicable
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?
deleted_user
Not applicable
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.
ChrisHemedinger
Community Manager
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
It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 902 views
  • 0 likes
  • 2 in conversation