How to force profile with SAS EG scheduled job

[RexDeus9]

Hi,

I run several SAS EG scheduled jobs on a Windows server. Using a VBS script and Task Manager all runs smoothly.

Now I need to run scheduled jobs on a different SAS network. How can I force my SAS EG projects to run with a specific user profile?

Rex

[Kurt_Bremser]

A google search for "sas enterprise guide specify profile on the commandline" immediately got me this:

https://blogs.sas.com/content/sasdummy/2009/08/03/using-sas-enterprise-guide-with-different-sas-envi...

by our revered @ChrisHemedinger

But honestly, you're passing the point where it's still feasible to use the crutch of scheduled EG projects.

Export your project codes to .sas files and have them run by central scheduling, using sasbatch.bat or sasbatch.sh.

[ChrisHemedinger]

I won't disagree with my friend @Kurt_Bremser that EG-based scheduling can scale only so much.  However, you can adjust your VB Script commands to set the active profile as your EG project starts up.

See this article for more information about EG Automation.  Included you'll find an example script that lists your available profiles.  And you can set the active profile with the SetActiveProfile method on the application object.

' Change if running a different version of EG
Dim egVersion 
egVersion = "SASEGObjectModel.Application.7.1"

Dim Application ' Application
Dim Project     ' Project object
Dim sasProgram  ' Code object (SAS program)
Dim n           ' counter

Set Application = CreateObject(egVersion)
' Set to your metadata profile name, or "Null Provider" for just Local server
Application.SetActiveProfile("My Server")

[RexDeus9]

Thank you Chris, appreciated!

Yvan