topic Re: How to force profile with SAS EG scheduled job in SAS Enterprise Guide

How to force profile with SAS EG scheduled job

RexDeus9 — Wed, 05 Sep 2018 12:04:45 GMT

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

Re: How to force profile with SAS EG scheduled job

Kurt_Bremser — Wed, 05 Sep 2018 12:17:19 GMT

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-environments/

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.

Re: How to force profile with SAS EG scheduled job

ChrisHemedinger — Wed, 05 Sep 2018 12:25:08 GMT

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")

Re: How to force profile with SAS EG scheduled job

RexDeus9 — Mon, 10 Sep 2018 00:31:31 GMT

Thank you Chris, appreciated!

Yvan